Re: Forms performance [need help!]

-> > ... AND ( (COL LIKE 'Ab%' OR
-> > COL LIKE 'aB%' OR
-> > COL LIKE 'ab%' OR
-> > COL LIKE 'AB%') AND UPPER(COL) = 'ABC') ...
-> ^^^^^
-> ^^^^^
-> note: function on indexed column?
->
-> >
-> > This will use an index on the COL column if another better index is
-> not > found by the optimizer.
->
-> I was informed on my Oracle tuning course that the moment you put a
-> FUNCTION on an indexed column the optimiser rejects using that index.

I believe the if you can force the values to be returned from the index (via the LIKE statements), then you can still examine it vie the upper(), but it is probably a shaky proposition. Received on Wed Oct 05 1994 - 22:09:00 CET