Beginning selection of qualifying indexes for table 'TAB1', varno = 0, objectid 144000513. The table (Datapages) has 9990 rows, 159 pages, Data Page Cluster Ratio 0.992806 Table scan cost is 9990 rows, 161 pages, using no data prefetch (size 2K I/O), in data cache 'default data cache' (cacheid 0) with LRU replacement Selecting best index for the SEARCH CLAUSE: TAB1.ID = 500 Estimated selectivity for ID, selectivity = 0.001001, upper limit = 0.053053. The best qualifying access is a table scan, costing 161 pages, with an estimate of 10 rows to be returned per scan of the table, using no data prefetch (size 2K I/O), in data cache 'default data cache' (cacheid 0) with LRU replacement Search argument selectivity is 0.001001.