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

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

Question Posted / guest

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

More DB Administration Interview Questions

What are the different types of database compression introduced in sql server 2008? : sql server DBA

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

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

Give two examples of how you might determine the structure of the table DEPT.

now one user in online.now i want drop him..how do u drop him?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

Give two methods you could use to determine what DDL changes have been made.

what is the use of ocr?

Give the stages of instance startup to a usable state where normal users may access it.

How to make a replica of existing oracle server to another server?

What are the different types of upgrades that can be performed in sql server? : sql server DBA

For more DB Administration Interview Questions Click Here