Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What are the factors you will check for the performane
optimization for a database query?

Answer Posted / ponguru

It is very big thing...Let me explain in short..Run the
profiler and catch the Logical reads/Physical reads/CUP
values.

find out where values are more(huge) and take Excution plan
and study it ...here you can find out where the problem.

In general scenarios Data also matters that means If your
Dev/Test enviroment not having that much Data which has
Prod.

Get the large Data and do above scenarios and you came know
what is cause.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List all the types of user-defined functions?

176


Describe in brief authentication modes in sql server.

199


Is it true, that there is no difference between a rule and a check constraint?

177


What is dbcc?

206


What are the steps you must follow to hide sql server instances?

168






What is command parameter in ssrs?

35


How can you check the level of fragmentation on a table?

183


How do I create a trace in sql server?

154


Define clusters?

246


What is the maximum number of index per table?

188


What is the difference between ddl,dml and dcl commands?

213


What are the acid properties?

199


What is sql view?

174


Write a program using SQL queries to find a unique entry in a table.

195


what is normalization? : Sql server database administration

156