WHAT IS LF_ROWS AND DEL_LF_ROWS IN INDEX_STATS TABLE AND DOES IT ONLY
HOLD ONE ROW
Number of leaf rows (values in the index)
Number of deleted leaf rows in the index
Index_stats only holds the results of the last ANALYZE INDEX VALIDATE STRUCTURE. It is also volatile - only available to the current session.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman