Analyze Index Validate Structure Index_Stats No rows selected
I am using Oracle 10g release 1.
I am trying to put one row of data into my INDEX_STATS view.
I am using "ANALYZE INDEX <index> VALIDATE STRUCTURE."
Next, I run SELECT COUNT(*) FROM INDEX_STATS.
I always get back the result: No rows selected.
I run, SELECT * FROM INDEX_STATS.
I never get back any data.
Everywhere I read, this "should work." Information should go into INDEX_STATS.
Any ideas, on how I can put data into INDEX_STATS?
Thanks,
Andre Mikulec