DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 1991, 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Explain Table Format Tool



******************** EXPLAIN INSTANCE ********************

DB2_VERSION: 		09.05.0
SOURCE_NAME: 		SQLC2G13
SOURCE_SCHEMA: 		NULLID  
SOURCE_VERSION: 	
EXPLAIN_TIME: 		2015-03-29-12.29.01.991002 
EXPLAIN_REQUESTER: 	ANTON   

Database Context:
----------------
	Parallelism: 		None
	CPU Speed: 		9,446885e-008
	Comm Speed: 		0
	Buffer Pool size: 	149408
	Sort Heap size: 	4246
	Database Heap size: 	1333
	Lock List size: 	29802
	Maximum Lock List: 	60
	Average Applications: 	1
	Locks Available: 	1519902

Package Context:
---------------
	SQL Type: 		Dynamic
	Optimization Level: 	5
	Blocking: 		Block All Cursors
	Isolation Level: 	Cursor Stability



---------------- STATEMENT 1  SECTION 203 ----------------
	QUERYNO: 		1
	QUERYTAG: 		                    
	Statement Type: 	Select
	Updatable: 		No
	Deletable: 		No
	Query Degree: 		1

Profile Information:
--------------------
OPT_PROF: (Optimization Profile Name)
	METR.PROFIL1
STMTPROF: (Statement Profile Name)
	Guidelines for my simplest query

Original Statement:
------------------
SELECT * 
FROM METR.CSM_CUSTOMER 
WHERE DELETE_DATE IS NULL


Optimized Statement:
-------------------
SELECT Q1.CSM_CODE AS "CSM_CODE", Q1.CUSTOMER_ID AS "CUSTOMER_ID", 
        Q1.ENTITY_ID AS "ENTITY_ID", Q1.CREATE_DATE AS "CREATE_DATE", 
        Q1.DELETE_DATE AS "DELETE_DATE", Q1.CREATION_ID AS "CREATION_ID", 
        Q1.DELETION_ID AS "DELETION_ID", Q1.RECSTATE AS "RECSTATE", 
        Q1.CUSTOMER_TYPE_ID AS "CUSTOMER_TYPE_ID", Q1.CUSTOMER_NAME AS 
        "CUSTOMER_NAME", Q1.INN AS "INN", Q1.OKPO AS "OKPO", Q1.OKONH AS 
        "OKONH", Q1.OKATO AS "OKATO", Q1.POSTCODE AS "POSTCODE", Q1.REGION AS 
        "REGION", Q1.ADDRESS AS "ADDRESS", Q1.POSTCODE_FACT AS 
        "POSTCODE_FACT", Q1.REGION_FACT AS "REGION_FACT", Q1.ADDRESS_FACT AS 
        "ADDRESS_FACT", Q1.PHONE AS "PHONE", Q1.E_MAIL AS "E_MAIL", Q1.FAX AS 
        "FAX", Q1.DIRECTOR AS "DIRECTOR", Q1.DIRECTOR_POSITION AS 
        "DIRECTOR_POSITION", Q1.GLAVBUH AS "GLAVBUH", Q1.LOCAL_CODE AS 
        "LOCAL_CODE", Q1.BANK AS "BANK", Q1.BIK AS "BIK", Q1.BANK_ACCOUNT AS 
        "BANK_ACCOUNT", Q1.LORO_ACCOUNT AS "LORO_ACCOUNT", Q1.OFK_NAME AS 
        "OFK_NAME", Q1.OFK_INN AS "OFK_INN", Q1.OFK_KPP AS "OFK_KPP", 
        Q1.OFK_LACCOUNT AS "OFK_LACCOUNT", Q1.OFK_OKONH AS "OFK_OKONH", 
        Q1.OFK_OKPO AS "OFK_OKPO", Q1.OFK_BANK AS "OFK_BANK", Q1.OFK_BIK AS 
        "OFK_BIK", Q1.OFK_BANK_ACCOUNT AS "OFK_BANK_ACCOUNT", 
        Q1.OFK_LORO_ACCOUNT AS "OFK_LORO_ACCOUNT", Q1.OFK_REQUISITES AS 
        "OFK_REQUISITES", Q1.BANK_BALANCE AS "BANK_BALANCE", Q1.CONTACT_PHONE 
        AS "CONTACT_PHONE", Q1.CONTACT_PERSON AS "CONTACT_PERSON", Q1.KPP AS 
        "KPP", Q1.OKATO_5 AS "OKATO_5", Q1.ARCHSTATE AS "ARCHSTATE" 
FROM METR.CSM_CUSTOMER AS Q1 
WHERE Q1.DELETE_DATE IS NULL 

Access Plan:
-----------
	Total Cost: 		3566,44
	Query Degree:		1

            Rows 
           RETURN
           (   1)
            Cost 
             I/O 
             |
            19020 
           FETCH 
           (   2)
           3566,44 
           3453,57 
          /---+---\
      19020        19092 
     IXSCAN   TABLE: METR    
     (   3)    CSM_CUSTOMER
     127,098 
     66,4052 
       |
      19092 
 INDEX: METR    
 IDX_DELETE_DATE

db2 explain all for SELECT * FROM METR.CSM_CUSTOMER WHERE DELETE_DATE IS NULL

 SET CURRENT OPTIMIZATION PROFILE = METR.PROFIL1

 SELECT * FROM METR.CSM_CUSTOMER WHERE DELETE_DATE IS NULL

db2exfmt -d CU242176 -1 -o exfmt.txt

Profile Information:
--------------------
OPT_PROF: (Optimization Profile Name)
	METR.PROFIL1
STMTPROF: (Statement Profile Name)
	Guidelines for my simplest query