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
- 11675 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 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?
How to use linked server?
Is the order of columns in the set clause important in ms sql server?
What is user-defined scalar function?
How to find the login name linked to a given user name?
What is a coalesce function?
What is sql view?
How to create a simple table to test triggers in ms sql server?
What is the difference between commit and rollback?
How to rename databases in ms sql server?
Explain how to send email from sql database?
Explain unique key in sql server?
What are the indexes in sql server?
What is #table in sql server?
What do you mean by SQL injection attack?
