What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 10527 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
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 do you start single user mode in clustered installations?
What is executereader?
What is 1nf 2nf and 3nf?
What are Row versions of DataRow?
What is data block and how to define data block size?
What is an index. What are the types?
What is optimization and its types?
What is the downside of using udf?
What is cursors?
What is Replication?
State a few properties of relational databases?
Explain the usage of floor function in sql server.
How to use transact-sql statements to access the database engine?
How to download microsoft sql server 2005 express edition?
How to generate random numbers with the rand() function in ms sql server?
