At great personal risk, I will tell you some secrets. There are many options. 1) Don't query data. To really enforce this, remove select, insert, update and delete privileges from all users. 2) If you must query data, use an index and only an index. Create indexes that cover all possible combinations of data in the table. 3) If you see a FULL TABLE SCAN coming your way, grab your cellphone and appear to be in deep conversation with someone and totally oblivious to everything around you (this is especially good when driving in heavy traffic). 4) If the FULL TABLE SCAN comes up to you and begins talking, pretend like you don't speak SQL.
And, just so I am not crucified by those with 0 sense of humor... read the previous posts on FTS! -----Original Message----- Sent: Tuesday, January 07, 2003 9:29 AM To: Multiple recipients of list ORACLE-L Hi How to avoid FULL TABLE SCAN? Thx -seema _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan 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).
