Re: how to use function-based indexes?

Mark Townsend wrote:

> 1) What happens if you say
> where UPPER(ACQUIRENTE_RAG_SOC) like upper('VERO%');

Nothing changes.  

> 2) How many rows in the table and what % of the rows qualify the condition ?
> - it's entirely possible that the FTS is faster than the index lookup

5/10904 = 0.05%. But perhaps what you say it's true. The query is indeed very fast!

Thanks for your help.
Best regards, Cristian

-- 
Cristian Veronesi ><((((º> http://www.crpa.it

There are no good wars, with the following exceptions: The American 
Revolution, World War II, and the Star Wars Trilogy. (Bart Simpson)