RE: FULL TABLE SCAN?

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Tue, 07 Jan 2003 09:15:44 -0800
Message-ID: <F001.00528BAE.20030107091544@fatcity.com>

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: oracledbam_at_hotmail.com

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: ListGuru_at_fatcity.com (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: Dan.Fink_at_mdx.com

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: ListGuru_at_fatcity.com (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). Received on Tue Jan 07 2003 - 11:15:44 CST