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

Answer Posted / jayesh

WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default fill factor value? : sql server DBA

579


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2010


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1882


how can you connect from 10g user to 11g user??

1689


what is asm?

625






Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

609


What is the difference between clustered and non-clustered index? : sql server DBA

555


what is grd?

648


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

557


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1534


what are the performance views in an oracle rac environment?

575


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

1554


what do you understand by fine-grained auditing?

643


how can a session indicate its interest in receiving alerts?

573


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

574