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: [EMAIL PROTECTED]
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: [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).
