Query processing is slow(eg select query)how will u solve that

Answer Posted / kumarayyalusamy

We will tune that query

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is replication? : sql server DBA

622


what is the use of ocr?

595


what is grd?

636


How can you control the amount of free space in your index pages? : sql server DBA

729


suppose you want to audit specific activities on sensitive data. How can you achieve that?

547






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

843


What is dcl? : sql server DBA

645


how can you get actual data change values from previous transactions in oracle?

609


Query processing is slow(eg select query)how will u solve that

6508


who owns the operating system files created by the utl_file package?

562


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1976


what is the role of dip user in our database?

2046


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1965


Explain about your sql server dba experience? : sql server DBA

545


what is the use of recording information about current session?

566