Analyze schema object (table, index, or cluster) - Oracle Schema

Q.  Why do you analyze a schema object (table, index, or cluster)?
- Published on 30 Jul 15

a. No need to Collect and manage statistics for it
b. Does not verify the validity of its storage format
c. UnIdentify migrated and chained rows of a table or cluster
d. None of the above

ANSWER: None of the above
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - You analyze a schema object (table, index, or cluster) to:
    1. Collect and manage statistics for it

    2. Verify the validity of its storage format

    3. Identify migrated and chained rows of a table or cluster

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)