Re: how to use function-based indexes?

Thomas Kyte wrote:

> also to use function based indexes -- we HAVE to use CBO. RBO doesn't "see"
> them. I'd suspect here they are using rbo.

I would like to thank Jim, Howard and Thomas for their answers.

Some more details:

• table ACQUIRENTI has 10904 rows
• I tried to issue the following command in order to force optimizer to use CBO:

SQL> ALTER SESSION SET OPTIMIZER_MODE = all_rows;

... but nothing changed. Moreover, I found the following note in the online doc "Oracle9i Database Performance Guide and Reference":

"Note: Even if the parameter OPTIMIZER_MODE is set to RULE, the use of these features [Partitioned tables and indexes, Function-based indexes etc.] enables the CBO."

• I tried to set column ACQUIRENTE_RAG_SOC to NOT NULL and I tried to match the function case: nothing changed.

Thanks again 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)