Query14

query14.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 = Yes (Bind Degree = ANY  )

	SQL Path                 = "SYSIBM", "SYSFUN", "SYSPROC", "SYSIBMADM", 
                                   "ITSURAYP"


Statement:
  
  select count(*)as count_value 
  from ADMLRAY.portletpreferences 
  where (ADMLRAY.portletpreferences.ownertype =?)and ( 
          (ADMLRAY.portletpreferences.portletid =?)or 
          (ADMLRAY.portletpreferences.portletid like coalesce(cast(? 
          as varchar(32672)), '')))

Intra-Partition Parallelism Degree = 8

Section Code Page = 1208

Estimated Cost = 59.660561
Estimated Cardinality = 1.000000

Process Using 8 Subagents
|  Access Table Name = ADMLRAY.PORTLETPREFERENCES  ID = 4,117
|  |  Index Scan:  Name = ADMLRAY.IX_A3B2A80C  ID = 6
|  |  |  Regular Index (Not Clustered)
|  |  |  Index Columns:
|  |  |  |  1: OWNERTYPE (Ascending)
|  |  |  |  2: PORTLETID (Ascending)
|  |  #Columns = 1
|  |  Parallel Scan
|  |  Skip Inserted Rows
|  |  Avoid Locking Committed Data
|  |  Currently Committed for Cursor Stability
|  |  #Key Columns = 1
|  |  |  Start Key: Inclusive Value
|  |  |  |  1: ? 
|  |  |  Stop Key: Inclusive Value
|  |  |  |  1: ? 
|  |  Index-Only Access
|  |  Index Prefetch: Sequential(6), Readahead
|  |  Lock Intents
|  |  |  Table: Intent Share
|  |  |  Row  : Next Key Share
|  |  Sargable Index Predicate(s)
|  |  |  #Predicates = 2
|  |  |  Partial Predicate Aggregation
|  |  |  |  Column Function(s)
|  Partial Aggregation Completion
|  |  Column Function(s)
|  Insert Into Asynchronous Local Table Queue  ID () = q1
Access Local Table Queue  ID () = q1  #Columns = 1
Final Aggregation
|  Column Function(s)
Return Data to Application
|  #Columns = 1

End of section


Optimizer Plan:

      Rows   
    Operator 
      (ID)   
      Cost   
            
       1    
    RETURN  
     ( 1)   
    59.6606 
      |     
       1    
     GRPBY  
     ( 2)   
    59.6602 
      |    
       1   
      LTQ  
     ( 3)  
     59.66 
      |    
      1    
    GRPBY  
     ( 4)  
    59.537 
     |     
   101.811 
   IXSCAN  
    ( 5)   
   59.5269 
     |       
    3014     
 Index:      
 ADMLRAY     
 IX_A3B2A80C