Question Ask A New Question Analyze structure validate table and then analyzing the index was
Hi experts.
Oracle version 10.2.0.3
I run the analyze validate structure for a table and then for an index, but it run way too fast for a table with millions of records. Is this ok?
The running of the dbv for the datafiles of the table and indexes run ok.
Here the log:
Subject: Speedprd Analyze Structure
23:00:01 SQL> analyze table srsuser.cdrs validate structure online;
Table analyzed.
23:00:02 SQL> commit;
Commit complete.
23:00:02 SQL> analyze index srsuser.cdrs_pk validate structure online;
Index analyzed.
23:00:09 SQL> commit;
Commit complete.
23:00:09 SQL> exit
Oracle version 10.2.0.3
I run the analyze validate structure for a table and then for an index, but it run way too fast for a table with millions of records. Is this ok?
The running of the dbv for the datafiles of the table and indexes run ok.
Here the log:
Subject: Speedprd Analyze Structure
23:00:01 SQL> analyze table srsuser.cdrs validate structure online;
Table analyzed.
23:00:02 SQL> commit;
Commit complete.
23:00:02 SQL> analyze index srsuser.cdrs_pk validate structure online;
Index analyzed.
23:00:09 SQL> commit;
Commit complete.
23:00:09 SQL> exit
0