Re^3: OT: Sql statement (how to ignore lower-upper case)

[pelagic]

in reply to Re^2: OT: Sql statement (how to ignore lower-upper case)
in thread OT: Sql statemet (how to ignore lower-upper case)

Interesting!
Even Oracle got their Funcion Based Index. If you know in advance that you will be using something like that, it helps a lot!

[thor]

From reading the doc, it is of significant note that it's expensive to maintain that index, as it needs to be re-computed for every insert and update. It's not something to take lightly. However, it might make sense to do this on a relatively static database, or one in which the maintainence time is irrelevant, but access time is key.