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
- 11379 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
Answer Posted / pushpendra kumar
The important factors for performance optimization are as
follows:
1. Proper data type assignment;
2. Selection of proper data reader;
3. Proper command to retrieve the data from the database.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is sql profiler. What are the default templates with it? : sql server database administration
Explain few of the new features of sql server 2008 management studio
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is a trigger and types of a trigger?
What is the filtered index?
Explain Geometry datatype in sql server 2008 with example
Why truncate is ddl command?
What do I need to start working with sql studio? : sql server management studio
What is the difference between the application object and session object?
How to start sql server browser service?
Explain ms sql server reporting services vs crystal reports?
How many types of attribute relationships are there? : sql server analysis services, ssas
Call by value and call by reference in procedure and function, with NOCOPY.
Can binary strings be converted into numeric or float data types?
What are trace files?
