What are the factors you will check for the performane
optimization for a database query?
Answer Posted / sravan kumar vemuri
The most important option to increase the query performance
is to create index on the table.
First one should concerntrate on the columns used in the
where cluase.
But indexes can hit the performance for insert queries. So
before giving an insert query, better to remove the index
and then to recreate the index.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how to define testing of network layers? : Sql server database administration
How do I determine how many instances of sql server are installed on a computer?
How many ways to create table-valued functions?
Explain different types of locks in sql server.
Explain the steps needed to create a scheduled job?
Why do we need different type of parameter?
SQL Server Architecture ?
Difference between report and query parameter. Why do we need different type of parameter?
What do you understand by recursive stored procedures?
What is a result set object returned by odbc_exec()?
Does a sql server 2005 select statement require a from?
What is the datatype of rowid?
Explain log shipping?
Does sql server 2000 clustering support load balancing?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration