Answer Posted / deepak
alter index <indexname> rebulid;
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the steps you will take to improve performance of a poor performing query?
Explain about your sql server dba experience? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what are the performance views in an oracle rac environment?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
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?
What the different types of replication and why are they used? : sql server DBA
how can you communicate with operating system files from oracle?
what is the use of recording information about current session?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is dcl? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you implement fine-grained auditing?