OraFAQ Forum: SQL & PL/SQL » Help!Query optimization Docs

Home » SQL & PL/SQL » SQL & PL/SQL » Help!Query optimization Docs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help!Query optimization Docs [message #21766]

Wed, 28 August 2002 13:24

Tony
Messages: 190
Registered: June 2001

Senior Member

Hi,
Could anyone give me some good reference/documentation on optimizing queries in oracle which explains some good techniques. Are there any tools available in oracle like sqlanalyzer in sqlserver? Where can I find cost based query analyzer and stuff? help!

Thanks
Tony

Report message to a moderator

Re: Help!Query optimization Docs [message #21770 is a reply to message #21766]

Wed, 28 August 2002 15:36

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Tools like TOAD make it easy to see the execution plans of statements. If you don't use that then the next choice would be to "set autotrace on" in sqlplus.
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a87503/sql_1016.htm
http://www.nwoug.com/download/9807db03.pdf

The basic tuning approach hasn't changed much since the Oracle 7 days - but of course there are fancy ways to tune for specific stuff in 8i and 9i.

Try to get a clean start by finding out what common myths are and ignore them. e.g. "using an index as always preferable to a full table scan" etc.

Report message to a moderator

Re: Help!Query optimization Docs [message #21774 is a reply to message #21766]

Wed, 28 August 2002 21:27

Tony
Messages: 190
Registered: June 2001

Senior Member

Thanks much.

Report message to a moderator

Previous Topic:	SQL Salary
Next Topic:	Last successful action using one query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:42:21 CDT 2024