DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What Is Lf_rows

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    What Is Lf_rows

    WHAT IS LF_ROWS AND DEL_LF_ROWS IN INDEX_STATS TABLE AND DOES IT ONLY
    HOLD ONE ROW

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    LF_ROWS
    NUMBER
    Number of leaf rows (values in the index)


    DEL_LF_ROWS
    NUMBER
    Number of deleted leaf rows in the index

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width