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
- 11669 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 do you know about system database? : SQL Server Architecture
What are drillthrough reports?
How to insert data into an existing table?
What is 'write-ahead log' in sql server 2000 ?
What is cross join in sql server joins?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is acid mean in sql server?
How do I manually uninstall an instance of sql server 2016?
How to use union to merge outputs from two queries together in ms sql server?
What are the different types of backups avaialabe in sql server 2005?
How much memory that we are using in Logshipping Concept?
What is data set in report?
Tell me what is the difference between locking and multi-versioning?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What does this statement do @@rowcount?
