ds

• Oct 26th, 2005

 

in database using   Hints

rajat

• Feb 9th, 2006

 

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

sekr

 Profile Answers by sekr Questions by sekr

• May 18th, 2006

 

can u explain in breif

vinoth kumar

• Dec 18th, 2006

 

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

Nikvik5

 Profile Answers by Nikvik5 

• Jun 23rd, 2009

 

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.