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
- 11380 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
Why is sql server log file full?
What are trace flags?
What is the syntax to execute the sys.dm_db_missing_index_details?
How you can change the database name in SQL SERVER?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
what is a live lock? : Sql server database administration
How do I view a procedure in sql server?
Why use “in” clause in sql server?
What is the full form of ddl?
What is difference between group by and having?
List the different index configurations possible for a table?
How to test a dml trigger in ms sql server?
What is default constraint?
How you can get the list of largest tables in a database?
is there a column to which a default can't be bound? : Sql server database administration
