how come there's nothing in INDEX_STATS despite ANALYZE INDEX <name> ?

[marist89]

COMPUTE STATISTICS doesn't populate index_stats. As pvl suggested, you must use VALIDATE STRUCTURE.

See http://otn.oracle.com/docs/products/...8a.htm#2058795 for details.