Home » RDBMS Server » Performance Tuning » Very first step (Oracle SQL Tuning)
Very first step [message #460709] Mon, 14 June 2010 05:05 Go to next message
Amitabhguha
Messages: 2
Registered: June 2010
Junior Member
Hi,

I just wanted to know the very first step when you see the sql which need to be tune.

Thanks in advance.

Report message to a moderator

Re: Very first step [message #460718 is a reply to message #460709] Mon, 14 June 2010 05:11 Go to previous messageGo to next message
Amitabhguha
Messages: 2
Registered: June 2010
Junior Member
Suppose i need to tune below query
SELECT * FROM emp where emp_id >1001

what should be my fist step?

Report message to a moderator

Re: Very first step [message #460722 is a reply to message #460718] Mon, 14 June 2010 05:15 Go to previous messageGo to next message
cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester
Senior Member
Read the sticky posts at the top of this forum.

Report message to a moderator

Re: Very first step [message #460732 is a reply to message #460722] Mon, 14 June 2010 05:36 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what should be my fist step?

cookiemonster wrote on Mon, 14 June 2010 12:15
Read the sticky posts at the top of this forum.


/forum/fa/2115/0/ Best answer.

Regards
Michel

Report message to a moderator

Previous Topic: Changing execution plans
Next Topic: Alternative to REPLACE function?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 12 22:58:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.