----- 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).
