OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Very first step (Oracle SQL Tuning)

Mon, 14 June 2010 05:05

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.

Mon, 14 June 2010 05:11

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?

Mon, 14 June 2010 05:15

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

Read the sticky posts at the top of this forum.

Mon, 14 June 2010 05:36

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Best answer.

Regards
Michel

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

Goto Forum:

]

Current Time: Tue Feb 18 23:45:15 CST 2025