DataStage - What is SQL tuning? how do you do it ?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 32 of 390

What is SQL tuning? how do you do it ?

Total Answers and Comments: 5

Last Update: June 23, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 26, 2005 06:31:43

RE: What is SQL tuning? how do you do it ?

in database using Hints

Is this answer useful? Yes | No

February 09, 2006 02:59:31

rajat

RE: What is SQL tuning? how do you do it ?

sql tunning can be done using cost based optimization

this parameters are very important of pfile

sort_area_size sort_area_retained_size db_multi_block_count open_cursors cursor_sharing

optimizer_mode choose/role

rajat

Is this answer useful? Yes | No

May 18, 2006 11:24:28

sekr

Member Since: December 2005 Contribution: 42

RE: What is SQL tuning? how do you do it ?

can u explain in breif

Is this answer useful? Yes | No

December 18, 2006 09:23:35

vinoth kumar

RE: What is SQL tuning? how do you do it ?

sql tunning how to per form thisin sql-server... through query analyser is needed and explain brief steps for tunnning

Is this answer useful? Yes | No

June 23, 2009 17:25:20

Nikvik5

Member Since: July 2008 Contribution: 1

RE: What is SQL tuning? how do you do it ?

SQL tuning is done by following steps:

- Run an Explain plan for SQL statement.

- Gather statistics for the tables.

- partition the tables when there is huge data.

- check for the sort_area_size buffercache logbuffer parameters.

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank