Re: Help - Tuning SQL

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Wed, 28 Feb 2001 13:47:06 -0800
Message-ID: <F001.002C01FE.20010228134652@fatcity.com>

Since you insisted on no guessing the only true test is for you to do it. Since we dont have your database to test it out on,

its time for you to bust out the documentation, look at explain plan, tkprof,.

Happy testing.

joe

I've got some simple questions on tuning SQL. Please reply with references,
I'm not looking for guesses.

• If you have a SELECT statement with a WHERE clause and 2 AND clauses, which one is processed first, the WHERE clause, the first AND clause, or the second AND clause?
• Is there any performance loss in using "<>" over "!="?

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline

--

Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :)
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Joseph S. Testa
  INET: teci_at_oracle-dba.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed Feb 28 2001 - 15:47:06 CST