This field gives the number of times Oracle Rdb fetched bottom level (leaf) nodes during index retrievals. This number, along with the "index scans" field, can indicate the length of scans in terms of index nodes accessed. There is one leaf node fetch for each "index lookup" retrieval.