Re: how to use function-based indexes?

From: Cristian Veronesi <c.veronesi_at_crpa.it>
Date: Tue, 11 Dec 2001 16:24:40 +0100
Message-ID: <3C162538.F77972CB@crpa.it>

Niall Litchfield wrote:

> Function based
> indexes are for cases where you are issuing queries like
>
> select * from acquirenti
> where upper(acquirente_rag_soc) like 'VERO%';

Sorry, in my second post I forgot to include the UPPER function in the query. But the problem still remains:

SQL> explain plan for
2 select * from acquirenti
3 where upper(acquirente_rag_soc) like 'VERO%';

Explained.

SQL> select * from plan_view;

OPERATION OPTIONS OBJECT_NAME POSITION

-------------------- -------------------- --------------------

SELECT STATEMENT
10

  TABLE ACCESS       FULL                 ACQUIRENTI

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)

Received on Tue Dec 11 2001 - 09:24:40 CST