| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: no values in index_stats view
scotts_at_t-com.com (scotts) wrote in news:32a2176f.0110251140.220b7318
@posting.google.com:
> after running:
> ANALYZE INDEX index_name VALIDATE STRUCTURE;
>
> there are no records in the index_stats view.
>
> what's up?
>
The sun is up.
[VALIDATE STRUCTURE] clause does NOT update any statistics. Try
COMPUTE STATISTICS
Received on Thu Oct 25 2001 - 19:30:09 CDT
 |
 |