Raj > do you know what do other columns stand for n4-n10 and n12 The "meaning" depends on the stats loaded in the table. Wolfgang documented some of them in his paper "Using DBMS_STATS in Access Path Optimization" (see http://www.centrexcc.com). HTH Chris -- //www.freelists.org/webpage/oracle-l