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
- 11648 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 nested transaction?
Explain filtered indexes benefits?
How many types of local tables are there in sql server?
Do you know what is rank function?
What type of locking occurs during the snapshot generation? : sql server replication
How do I save a stored procedure in sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to create function without parameter in sql server?
What is the purpose of the master database?
What are the rendering extensions of ssrs?
How do I create a trace in sql server?
What do you mean by an execution plan? Why is it used?
What is the maximum size of column in sql server?
Do you know what are acid properties?
Is the order of columns in the set clause important in ms sql server?
