Home » RDBMS Server » Performance Tuning » Query Tuning (oracle 10g)
Query Tuning [message #317564] Thu, 01 May 2008 23:46 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I need to tune a Query can any one help me ,what are the steps to be followed by to tune a query

Thanks,
Re: Query Tuning [message #317566 is a reply to message #317564] Thu, 01 May 2008 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
which of the above have you tried & what were the results?
Re: Query Tuning [message #317859 is a reply to message #317566] Sun, 04 May 2008 06:51 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try using this tuning guide: http://www.orafaq.com/tuningguide

Ross Leishman
Re: Query Tuning [message #319977 is a reply to message #317564] Tue, 13 May 2008 09:57 Go to previous message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member


first step is right indexing
Previous Topic: DeadLock in the database
Next Topic: Error while creating partitioned table
Goto Forum:
  


Current Time: Sun Dec 04 08:28:22 CST 2016

Total time taken to generate the page: 0.24198 seconds