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,

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
BlackSwan
Messages: 26766
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?

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: 3728
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) ] [ RSS ]

Current Time: Sat Nov 23 01:26:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.