Re: how to use function-based indexes?

Niall Litchfield wrote:

> how many rows does your query return?

5 rows from 10904

> how many blocks in the table?

64

> have you analyzed the table (sorry can't find if you've posted this info or
> not).

Yes, I did:

SQL> analyze table acquirenti compute statistics ;

Table analyzed.

> if this is performance critical - I read your posts as just investigation -
> you could of course hint the statement.

I tried, with the same result:

SQL> explain plan for
  2 select * from acquirenti /*+ INDEX(acquirenti xie1acquirenti) */   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                  1

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)