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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What types of replication are supported in sql server? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What authentication modes does sql server support? : sql server DBA
How to start SQL Server in minimal configuration mode?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what are the differences of where and if in SAS?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?