Answer Posted / nishi
When we issue ANALYZE TABLE with the computes statistics command, the entire Oracle table is analyzed via a full-table scan. Upon completion of the Oracle ANALYZE TABLE command, very accurate statistics are then placed inside the data dictionary for use by the cost-based optimizer.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category