What are the factors you will check for the performane
optimization for a database query?
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
Does partitioning improve performance sql server?
How do I debug a stored procedure in sql server?
How to enable/disable indexes?
In which files does sql server actually store data?
How can you append an identity column to a temporary table?
What is the largest component inside a field?
Can two tables have the same primary key?
Explain candidate key, alternate key, and composite key?
Explain the categories of stored procedure?
What are the methods used to protect against sql injection attack?
How to convert a unicode strings to non-unicode strings?
What are the 2 types of classifications of constraints in the sql server?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What area unit the various kinds of info compression introduced in sql server 2008?
What is conditional split?