Re: query performance -- revised!

> There is certhainly a threshold where optimizer switches to FTS. The
> question might be if this switch happens too early. One way to check that is
> comparing estimated cardinalities at each rowsource against rows returned
> reportes as a part of execution statistics. If there is large discrepancy,
> then it is likely that optimizer decides switching to FTS too early in our
> case.

Absolutely! But unfortunately, we don't know the answer to that since information like how many rows in the table, how many rows get returned, etc. are missing from the original post. And INIT.ORA parameters can control how early CBO switches to FTS.

Cheers!
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam" from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"