Case Insensitive Indexes

XMLWordPrintable

      Matchgrids should be constructed with lower case indexes on case insensitive attributes. eg:

      CREATE INDEX foo ON mg_testgrid ((lower(firstname)));

      Note this will increase the cost of index construction on new records. Possibly drop the case sensitive index if it's not used anywhere.

            Assignee:
            Benn Oshrin (internet2.edu)
            Reporter:
            Benn Oshrin (internet2.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: