connect to test@

create table ex (
	id int not null,
	name char( 30 ),
	constraint PK primary key (id)
)@

commit@

select * from ex where id=? @
select * from ex where id=? selectivity  1 . 0  @

DB2 Universal Database Version  8 . 1 ,  5622 - 044  (c) Copyright IBM Corp.  1991 ,  2002 
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool
DB2 Universal Database Version  8 . 1 ,  5622 - 044  (c) Copyright IBM Corp.  1991 ,  2002 
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool

******************* DYNAMIC ***************************************

==================== STATEMENT ==========================================

	Isolation Level          = Cursor Stability
	Blocking                 = Block Unambiguous Cursors
	Query Optimization Class =  5 

	Partition Parallel       = No
	Intra-Partition Parallel = No

	SQL Path                 = "SYSIBM", "SYSFUN", "SYSPROC", "DB2ADMIN"


SQL Statement:
  
  select * 
  from ex 
  where id=?


Section Code Page =  1251 

Estimated Cost =  12 , 884914 
Estimated Cardinality =  1 , 000000 

Access Table Name = DB2ADMIN.EX  ID =  2 , 19 
|  Index Scan:  Name = SYSIBM.SQL050127105951350  ID =  1 
|  |  Regular Index (Not Clustered)
|  |  Index Columns:
|  |  |   1 : ID (Ascending)
|  #Columns =  1 
|  Single Record
|  Fully Qualified Unique Key
|  #Key Columns =  1 
|  |  Start Key: Inclusive Value
|  |  |  |   1 : ?
|  |  Stop Key: Inclusive Value
|  |  |  |   1 : ?
|  Data Prefetch: Eligible  0 
|  Index Prefetch: None
|  Lock Intents
|  |  Table: Intent Share
|  |  Row  : Next Key Share
|  Sargable Predicate(s)
|  |  Return Data to Application
|  |  |  #Columns =  2 
Return Data Completion

End of section


Optimizer Plan:

               RETURN 
               (    1 ) 
                 |    
               FETCH  
               (    2 ) 
              /      \
       IXSCAN        Table:   
       (    2 )        DB2ADMIN 
         |           EX       
 Index:             
 SYSIBM             
 SQL050127105951350 


==================== STATEMENT ==========================================

	Isolation Level          = Cursor Stability
	Blocking                 = Block Unambiguous Cursors
	Query Optimization Class =  5 

	Partition Parallel       = No
	Intra-Partition Parallel = No

	SQL Path                 = "SYSIBM", "SYSFUN", "SYSPROC", "DB2ADMIN"


SQL Statement:
  
  select * 
  from ex 
  where id=? selectivity  1 . 0 


Section Code Page =  1251 

Estimated Cost =  12 , 951826 
Estimated Cardinality =  1 , 000000 

Access Table Name = DB2ADMIN.EX  ID =  2 , 19 
|  #Columns =  1 
|  Single Record
|  Relation Scan
|  |  Prefetch: Eligible
|  Lock Intents
|  |  Table: Intent Share
|  |  Row  : Next Key Share
|  Sargable Predicate(s)
|  |  #Predicates =  1 
|  |  Return Data to Application
|  |  |  #Columns =  2 
Return Data Completion

End of section


Optimizer Plan:

  RETURN 
  (    1 ) 
    |    
  TBSCAN 
  (    2 ) 
    |    
 Table:   
 DB2ADMIN 
 EX