Query 15

query15.expl

DB2 Universal Database Version 10.5, 5622-044 (c) Copyright IBM Corp. 1991, 2012
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY Explain Tool

DB2 Universal Database Version 10.5, 5622-044 (c) Copyright IBM Corp. 1991, 2012
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY 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", "SYSIBMADM", 
                                   "ITSURAYP"


Statement:
  
  select count(*)as count_value 
  from ADMLRAY.portletpreferences 
  where (ADMLRAY.portletpreferences.ownerid =?)and 
          (ADMLRAY.portletpreferences.ownertype =?)and ( 
          (ADMLRAY.portletpreferences.portletid =?))and 
          (ADMLRAY.portletpreferences.plid =?)


Section Code Page = 1208

Estimated Cost = 14.118731
Estimated Cardinality = 1.000000

Access Table Name = ADMLRAY.PORTLETPREFERENCES  ID = 4,117
|  Index Scan:  Name = ADMLRAY.IX_C7057FF7  ID = 3
|  |  Regular Index (Not Clustered)
|  |  Index Columns:
|  |  |  1: OWNERID (Ascending)
|  |  |  2: OWNERTYPE (Ascending)
|  |  |  3: PLID (Ascending)
|  |  |  4: PORTLETID (Ascending)
|  #Columns = 0
|  Single Record
|  Fully Qualified Unique Key
|  Skip Inserted Rows
|  Avoid Locking Committed Data
|  Currently Committed for Cursor Stability
|  #Key Columns = 4
|  |  Start Key: Inclusive Value
|  |  |  1: ? 
|  |  |  2: ? 
|  |  |  3: ? 
|  |  |  4: ? 
|  |  Stop Key: Inclusive Value
|  |  |  1: ? 
|  |  |  2: ? 
|  |  |  3: ? 
|  |  |  4: ? 
|  Index-Only Access
|  Index Prefetch: Sequential(1), Readahead
|  Lock Intents
|  |  Table: Intent Share
|  |  Row  : Next Key Share
Aggregation
|  Column Function(s)
Return Data to Application
|  #Columns = 1

End of section


Optimizer Plan:

     Rows   
   Operator 
     (ID)   
     Cost   
           
      1    
   RETURN  
    ( 1)   
   14.1187 
     |     
      1    
    GRPBY  
    ( 2)   
   14.1184 
     |     
      1    
   IXSCAN  
    ( 3)   
   14.1182 
     |       
    50612    
 Index:      
 ADMLRAY     
 IX_C7057FF7