Home » RDBMS Server » Server Administration » Query Optimization in Oracle
Query Optimization in Oracle [message #54824] Mon, 09 December 2002 01:05 Go to next message
Rupak Basak
Messages: 9
Registered: December 2002
Junior Member
Hello,

Could anybody help me with the processes/steps Oracle follows in Query Optimization?

Regards,

/Rupak

Report message to a moderator

Re: Query Optimization in Oracle [message #54838 is a reply to message #54824] Mon, 09 December 2002 12:18 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
It's a big topic, so best to get familiar with:
[*]indexes
[*]analyze table (or dbms_stats package)
[*]autotrace in sqlplus
[*]tkprof

Read the YAPP document on otn.oracle.com or this URL:

Report message to a moderator

Previous Topic: Enterprise versus Standard
Next Topic: _system_trig_enabled
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:36:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.