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

How can sql server instances be hidden?

528


What is the difference between having clause and where clause in sql server?

575


What does Master database contains?

630


What do you need to connect php to sql server?

545


How many database files are there in sql server 2000?what are they?

583






What is acid properties?

597


What is a transaction and why is it important?

573


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

538


What does set rowcount do?

515


How do I view views in sql server?

520


What is optimization and its types?

539


how many clustered indexes can be created on a table? : Sql server database administration

569


What happens if the update subquery returns no rows in ms sql server?

592


List out different types of normalizations in sql server and explain each of them?

559


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

593