Function Based indexes

Function based indexes seem really interesting (ok so I'm sad) but I have seen very little written about them (i.e. Thomas Kyte's article).

So far I have gathered three useful features that can be implemented using them:

1. Uppercase indexes (as described in TK's article)
2. Composite key index search from a given key using greater than (e.g. MyCompKey(x,y,z) > MyCompKey('a','b','c')
3. Sparse indexes (i.e. were you require only certain values for non unique indexes to reduce long chains).

Can anyone think of any other good uses. Received on Fri May 21 1999 - 07:51:07 CDT