Question: To generate database object statistics manually, following syntax should be used in Oracle: a ) ANALYZE object _ name COMPUTE STATISTICS; b ) ANALYZE object

To generate database object statistics manually, following syntax should be used in Oracle:
a) ANALYZE object_name COMPUTE STATISTICS;
b) ANALYZE object_name;
C) CREATE TABLE/INDEX > object_name;
d) CREATE object_name COMPUTE STATISTICS;
 To generate database object statistics manually, following syntax should be used

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!