Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11644 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
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
What are different types of table joins?
How can you fetch alternate records from a table?
What is inner join in sql server joins?
Which sql server is best?
Why use identity in sql server?
What are cursors and when they are useful?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is difference between joins and subqueries?
Is sql different from sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is temporary table in sql server? Why we use temp table?
What is a primary index?
How to create function without parameter in sql server?
What is a join in sql? What are the types of joins?
How can you hide the sql server instances?
