Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mohapatra.gouranga@gmail.com
> Index rebuild nothing of Drop and re-create of Index.
> Is usefull to move index from one tablespace to other.
> Do not do if not necessary.
> In case of migration, do only validate structure for the
indexex.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is a crs resource?
how can you get actual data change values from previous transactions in oracle?
What is transparent data encryption? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what are the benefits of flashback feature?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Query processing is slow(eg select query)how will u solve that
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Where do you find the default index fill factor and how to change it? : sql server DBA
what is the use of recording information about current session?
