Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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


Please Help Members By Posting Answers For Below Questions

What is a trigger? Why we need it?

197


What is dirty page?

217


What are scalar functions?

175


State the difference between local and global temporary tables?

173


What are the differences between local and global temporary tables?

186






Explain full-text query in sql server?

194


Tell me about normalization in DBMS.

228


What are the extra roles available in msdb? : sql server security

185


Mention the differences between having and where clause.

211


What command would you use to create an index?

204


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1060


State the difference between union and union all?

170


How to find the version of sql server? : sql server database administration

223


Can sql servers link to other servers?

168


What is acid db?

141