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 the importance of a recovery model? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What is dbcc? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
when does an alert gets signaled?
How would you go about verifying the network name that the local_listener is currently using?
what is asm?
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
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
how can you communicate with operating system files from oracle?
what is grd?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Why does Oracle not permit the use of PCTUSED with indexes?