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. 


Estimating selectivity of index 'TAB1_ID_INDX', indid 2 
   scan selectivity 0.001001, filter selectivity 0.001001  
   10 rows, 3 pages, index height 1, 
   Data Row Cluster Ratio 0.999797, 
   Index Page Cluster Ratio 1.000000, 
   Data Page Cluster Ratio 0.978723 




The best qualifying  index is 'TAB1_ID_INDX' (indid 2) 
   costing 3 pages, 
   with an estimate of 10 rows to be returned per scan of the table, 
   using no index prefetch (size 2K I/O) on leaf pages, 
   in index cache 'default data cache' (cacheid 0) with LRU replacement 
   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.