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 are the different ways you can create databases in sql server? : sql server DBA
what are the benefits of flashback feature?
What are the recovery models for a database? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are statistics, under what circumstances they go out of date, how do you update them?
what functionality does oracle provide to secure sensitive information?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the commands used in dcl? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the operating modes in which database mirroring runs? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
what is a crs resource?
what is the diffrence between core dba and apps dba?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
