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
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain in brief how sql server enhances scalability of the database system?
What is the purpose of optimization?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the difference between having clause and where clause in sql server?
What are binary string data types in ms sql server?
What is cursors? And what are the different types of cursor?
What is the difference between count and distinct count?
What is tempdb in sql server?
How to restore performance issues and how to check?
How to generate create view script on an existing view?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What the different types of Replication and why are they used?
What are the differences between triggers and stored procedures?
What is the difference between substr and charindex in the sql server?