Use The Index, Luke explains the concept of function based indexes. What can function based indexes be used for? Do you have any examples? asked Aug 31 '10 at 11:46 Markus Winand ♦♦ |
For queries using upper or other functions in the where clause, that cannot use "normal" B-Tree indexes:
answered Nov 11 '10 at 09:01 shirleymanson |