1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What are the steps you will take to improve performance of
a poor performing query?

Question Posted / guest


What are the steps you will take to improve performance of a poor performing query?..

Answer / Binu Kumar Gautam

Steps to improve query performance include: 1) Reviewing query plan and indexes, 2) Optimizing queries by rewriting them or adding appropriate indexes, 3) Reducing the amount of data fetched, 4) Using stored procedures instead of ad-hoc queries, 5) Considering partitioning large tables, and 6) Monitoring database and server performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

What the different topologies in which replication can be configured? : sql server DBA

1 Answers  

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1 Answers  

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

How can you enable a trace for a session?

1 Answers  

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

internal architecture

1 Answers   CSC,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

How would you go about generating an EXPLAIN plan?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories