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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

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

1 Answers  


how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,


What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,


what is the use of ocr?

0 Answers   Oracle,


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  






What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  


How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


what is ora 24313?what is the procedure to exclude that error?

0 Answers  


Categories