Answer Posted / deepak
alter index <indexname> rebulid;
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is the default fill factor value? : sql server DBA
how can you enable flashback feature?
What are the different types of indexes available in sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what are the differences of where and if in SAS?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is logical system in sap basis
what is the role of dip user in our database?
what do you understand by fine-grained auditing?
What are statistics, under what circumstances they go out of date, how do you update them?