What are the factors you will check for the performane
optimization for a database query?

Answer Posted / bata

i think above 2 answers arent much betr.wil try to give
perfect answer soon

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the disadvantages of cursors? : Sql server database administration

683


What is the server name in sql server?

714


what is blocking? : Sql server database administration

714


Explain where clause?

731


What is the difference between ‘having’ clause and a ‘where’ clause?

768






Would you store your query in a ssrs report or a database server? State the reason why?

132


How to filter out duplications in the returning rows in ms sql server?

808


How do you clear a log file?

709


What is repeatable read?

695


Which are the third-party tools used in sql server and why would you use them?

657


Explain unique key in sql server?

719


how to trace the traffic hitting a sql server? : Sql server database administration

1417


How to stop log file growing too big?

747


Does the unique constraint create an index?

740


What is a partition function in sql server?

699