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
What is the default fill factor value? : sql server DBA
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?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you connect from 10g user to 11g user??
what is asm?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
what is grd?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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
what are the performance views in an oracle rac environment?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what do you understand by fine-grained auditing?
how can a session indicate its interest in receiving alerts?
What are the different types of database compression introduced in sql server 2008? : sql server DBA