That type of index supression spending 15 to 20 minutes and when it was modifed it took less than a second as column was perfectly indexed. Those codes were atleast not modified in version 10.7. There was no concept of function based indexes either as optimizer was rule based(regardless of 8i).
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 22 Oct 2003 02:44:25 -0800
----- Original Message -----
> im assuming this is an old 'trick' from RBO days. Alot of these are still floating around. Wasnt there one when you
wanted to force a full table scan you would go
>
> where num_field = 1 + 0;
>
> the + 0 forced the full table scan? I was on a project earlier this year and one guy told people to use it.
>
Actually, that one is still valid. Along with using any function around a predicate column. In general, an expression instead of the column name in a predicate will force ignoring of any conventional indexes on that column. Of course, function-based indexes were made just for that.
Cheers Nuno Souto [EMAIL PROTECTED]
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
_________________________________________________________________
Cheer a special someone with a fun Halloween eCard from American Greetings! Go to http://www.msn.americangreetings.com/index_msn.pd?source=msne134
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
