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
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|
What is a trigger? Why we need it?
What is dirty page?
What are scalar functions?
State the difference between local and global temporary tables?
What are the differences between local and global temporary tables?
Explain full-text query in sql server?
Tell me about normalization in DBMS.
What are the extra roles available in msdb? : sql server security
Mention the differences between having and where clause.
What command would you use to create an index?
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?)
State the difference between union and union all?
How to find the version of sql server? : sql server database administration
Can sql servers link to other servers?
What is acid db?