Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007

    Unanswered: INDEX FULLKEYCARD and number of leafpages

    Hi friends,

    For any index is it true that indexfullkey cardinality would be approximately equivalent to number of indexrows that will be scanned for a nonmatching column scan.??

    And what does a filter factor of 0.0 mean??If there is a index on ID,LNAME and only LNAME is used in WHERE clause,i believe the filter factor would be 0.0 in this case and the index slice would be all the index rows..Please correct me if i am wrong


  2. #2
    Join Date
    May 2003
    Index fullkeycard is the number of unique values in the complete index (all columns of the index). If a non-matching full index scan is necessary (the b-tree is not used) then all the leaf pages (and all the index entries) need to be accessed to resolve the query (assuming that is the access path chosen by DB2).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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