Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 81
Registered: February 2008
Location: india
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,
Report message to a moderator
Re: Query Tuning [message #317566 is a reply to message #317564 ] Thu, 01 May 2008 23:52 Go to previous messageGo to next message
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
which of the above have you tried & what were the results?
Report message to a moderator
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: 2563
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try using this tuning guide: http://www.orafaq.com/tuningguide
Ross Leishman
Report message to a moderator
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
Report message to a moderator
Previous Topic:DeadLock in the database
Next Topic:Error while creating partitioned table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Fri May 16 23:05:11 CDT 2008

Total time taken to generate the page: 0.82889 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.