Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query performance -- revised!
>I have corrected my syntax and there is
When you add more "OR" statements, you will be returning more rows from the table. At some point, the optimizer decides that a full table scan is preferrable to an index scan based on the percentage of rows returned.
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"Received on Thu May 29 2003 - 08:22:07 CDT