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 benefits of flashback feature?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What purpose does the model database server? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is dcl? : sql server DBA
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?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what is the role of dip user in our database?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Explain materialized views and how they are used.
Where do you find the default index fill factor and how to change it? : sql server DBA