Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11915 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 many types of keys are there?
What are the advantages of using cte?
Can we add an identity column to decimal datatype?
What is proper subset of candidate key?
What are the components of sql server service broker?
What are out-of-range errors with date and time literals?
Explain how to integrate the ssrs reports in application?
Does a server store data?
What are the different types of collation sensitivity?
We need to perform what steps in the following order to work with a cursor?
What are the different types of replication are there in sql server 2000?
Can a trigger be created on a view?
What the difference between UNION and UNIONALL?
How to make a column nullable?
What is the difference between delete and truncate statements?
