SEO

Query1)
select avg(demo_value) from userid.std_demo_data a, userid.css_defn b,
userid.data_repository2 c
where b.service = 12 and a.service = 12
and a.css_id = b.css_id
and a.recdate between '09/01/2007' and '11/01/2007'
and c.surv_id = a.surv_id and quest_id = 36311
group by a.css_id with ur;

Query2)
select avg(demo_value) from userid.std_demo_data a,
userid.data_repository2 c
where a.service = 12
and a.recdate between '09/01/2007' and '11/01/2007'
and c.surv_id = a.surv_id and quest_id = 36311
group by a.css_id with ur;

Query 1 took almost 7 minutes to run where Query 2 was just over 2
minutes.

The css_defn table has a index with service, client_id and site_id.

For the NLJoin (#7), there is an input stream which is not quite clear
to me what that means.


************ Explain for Query
1*******************************************
******************** EXPLAIN INSTANCE ********************

DB2_VERSION: 09.01.3
SOURCE_NAME: SQLC2F0A
SOURCE_SCHEMA: NULLID
SOURCE_VERSION:
EXPLAIN_TIME: 2008-03-14-13.15.46.911763
EXPLAIN_REQUESTER: USERID

Database Context:
----------------
Parallelism: Intra-Partition Parallelism
CPU Speed: 2.361721e-07
Comm Speed: 100
Buffer Pool size: 1933448
Sort Heap size: 45000
Database Heap size: 32000
Lock List size: 24000
Maximum Lock List: 80
Average Applications: 1
Locks Available: 1228800

Package Context:
---------------
SQL Type: Dynamic
Optimization Level: 5
Blocking: Block All Cursors
Isolation Level: Uncommitted Read



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

Original Statement:------------------
select avg(demo_value)
from userid.std_demo_data a, userid.css_defn b,
userid.data_repository2 c
where b.service = 12 and a.service = 12 and a.css_id = b.css_id and
a.recdate
between '09/01/2007' and '11/01/2007' and c.surv_id =
a.surv_id and
quest_id = 36311
group by a.css_id
with ur


Optimized Statement:
-------------------
SELECT (Q5.$C0 / Q5.$C1)
FROM
(SELECT SUM(Q4.$C1), COUNT(*)
FROM
(SELECT Q3.CSS_ID, Q1.DEMO_VALUE
FROM USERID.DATA_REPOSITORY2 AS Q1, USERID.CSS_DEFN AS Q2,
USERID.STD_DEMO_DATA AS Q3
WHERE (Q1.QUEST_ID = 36311) AND (Q1.SURV_ID = Q3.SURV_ID) AND
(Q3.RECDATE <= '11/01/2007') AND ('09/01/2007' <=
Q3.RECDATE)
AND (Q3.CSS_ID = Q2.CSS_ID) AND (Q3.SERVICE = 12) AND
(Q2.SERVICE = 12)) AS Q4
GROUP BY Q4.$C0) AS Q5

Access Plan:
-----------
Total Cost: 15214.6
Query Degree: 8

Rows
RETURN
( 1)
Cost
I/O
|
0.0151402
GRPBY
( 2)
15214.6
2046.17
|
0.0151402
LMTQ
( 3)
15214.6
2046.17
|
0.0151402
GRPBY
( 4)
15214.5
2046.17
|
0.0151402
TBSCAN
( 5)
15214.5
2046.17
|
0.0151402
SORT
( 6)
15214.5
2046.17
|
0.0151402
NLJOIN
( 7)
15214.5
2046.17
/--------------------
+--------------------\
11.916
0.00127058

NLJOIN FETCH

( 8) ( 15)

14944 22.7119

2010.41 3.00127
/-----------+----------
\ /----+----\
652.189 0.0182708
0.00127058 2.21331e+09
FETCH FETCH
IXSCAN TABLE: USERID
( 9) ( 13)
( 16) DATA_REPOSITORY2
56.2909 22.8403
22.7021
41.9245 3.01827 3
/---+---\ /----+---\ |
652.189 34566 0.0182708 6.8794e+07 2.21331e
+09
RIDSCN TABLE: USERID IXSCAN TABLE: USERID INDEX:
SYSIBM
( 10) CSS_DEFN ( 14) STD_DEMO_DATA
SQL080313101944640
16.1318 22.7019
2.07547 3
| |
652.189 6.8794e+07
SORT INDEX: USERID
( 11) SFRD2
16.1315
2.07547
|
652.189
IXSCAN
( 12)
15.9772
2.07547
|
34566
INDEX: USERID
CLI_SITE_SERV2




Extended Diagnostic Information:
--------------------------------

No extended Diagnostic Information for this statment.


Plan Details:
-------------


1) RETURN: (Return Result)
Cumulative Total Cost: 15214.6
Cumulative CPU Cost: 2.93821e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03692
Cumulative Re-CPU Cost: 2.13273e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.6
Estimated Bufferpool Buffers: 0

Arguments:
---------
BLDLEVEL: (Build level)
DB2 v9.1.0.3 : s070914
HEAPUSE : (Maximum Statement Heap Usage)
112 Pages
STMTHEAP: (Statement heap size)
10000

Input Streams:
-------------
21) From Operator #2

Estimated number of rows:
0.0151402
Number of columns: 1
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q6.$C0


2) GRPBY : (Group By)
Cumulative Total Cost: 15214.6
Cumulative CPU Cost: 2.93812e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03671
Cumulative Re-CPU Cost: 2.13264e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.6
Estimated Bufferpool Buffers: 0

Arguments:
---------
AGGMODE : (Aggregration Mode)
FINAL
GROUPBYC: (Group By columns)
TRUE
GROUPBYN: (Number of Group By columns)
1
GROUPBYR: (Group By requirement)
1: Q4.CSS_ID
ONEFETCH: (One Fetch flag)
FALSE

Input Streams:
-------------
20) From Operator #3

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


Output Streams:
--------------
21) To Operator #1

Estimated number of rows:
0.0151402
Number of columns: 1
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q6.$C0


3) TQ : (Table Queue)
Cumulative Total Cost: 15214.6
Cumulative CPU Cost: 2.93809e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03665
Cumulative Re-CPU Cost: 2.13262e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.6
Estimated Bufferpool Buffers: 0

Arguments:
---------
LISTENER: (Listener Table Queue type)
FALSE
SORTKEY : (Sort Key column)
1: Q4.CSS_ID(A)
TQ TYPE : (Table queue type)
LOCAL
TQDEGREE: (Degree of Intra-Partition parallelism)
8
TQMERGE : (Merging Table Queue flag)
TRUE
TQREAD : (Table Queue Read type)
READ AHEAD
UNIQUE : (Uniqueness required flag)
FALSE

Input Streams:
-------------
19) From Operator #4

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


Output Streams:
--------------
20) To Operator #2

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


4) GRPBY : (Group By)
Cumulative Total Cost: 15214.5
Cumulative CPU Cost: 2.90559e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03665
Cumulative Re-CPU Cost: 2.13262e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.5
Estimated Bufferpool Buffers: 0

Arguments:
---------
AGGMODE : (Aggregration Mode)
PARTIAL
GROUPBYC: (Group By columns)
TRUE
GROUPBYN: (Number of Group By columns)
1
GROUPBYR: (Group By requirement)
1: Q4.CSS_ID
ONEFETCH: (One Fetch flag)
FALSE

Input Streams:
-------------
18) From Operator #5

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


Output Streams:
--------------
19) To Operator #3

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


5) TBSCAN: (Table Scan)
Cumulative Total Cost: 15214.5
Cumulative CPU Cost: 2.90557e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03659
Cumulative Re-CPU Cost: 2.13259e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.5
Estimated Bufferpool Buffers: 0

Arguments:
---------
MAXPAGES: (Maximum pages for prefetch)
ALL
PREFETCH: (Type of Prefetch)
NONE
SCANDIR : (Scan Direction)
FORWARD

Input Streams:
-------------
17) From Operator #6

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


Output Streams:
--------------
18) To Operator #4

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


6) SORT : (Sort)
Cumulative Total Cost: 15214.5
Cumulative CPU Cost: 2.90541e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03622
Cumulative Re-CPU Cost: 2.13244e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.5
Estimated Bufferpool Buffers: 2047.17

Arguments:
---------
DUPLWARN: (Duplicates Warning flag)
FALSE
NUMROWS : (Estimated number of rows)
1
ROWWIDTH: (Estimated width of rows)
12
SORTKEY : (Sort Key column)
1: Q4.CSS_ID(A)
TEMPSIZE: (Temporary Table Page Size)
8192
UNIQUE : (Uniqueness required flag)
FALSE

Input Streams:
-------------
16) From Operator #7

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.DEMO_VALUE+Q4.CSS_ID


Output Streams:
--------------
17) To Operator #5

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.CSS_ID(A)+Q4.DEMO_VALUE


7) NLJOIN: (Nested Loop Join)
Cumulative Total Cost: 15214.5
Cumulative CPU Cost: 2.90514e+07
Cumulative I/O Cost: 2046.17
Cumulative Re-Total Cost: 5.03622
Cumulative Re-CPU Cost: 2.13244e+07
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 15214.5
Estimated Bufferpool Buffers: 2047.17

Arguments:
---------
EARLYOUT: (Early Out flag)
LEFT
FETCHMAX: (Override for FETCH MAXPAGES)
IGNORE
ISCANMAX: (Override for ISCAN MAXPAGES)
IGNORE

Predicates:
----------
5) Predicate used in Join
Comparison Operator: Equal (=)
Subquery Input Required: No
Filter Factor: 1.45362e-08

Predicate Text:
--------------
(Q1.SURV_ID = Q3.SURV_ID)


Input Streams:
-------------
11) From Operator #8

Estimated number of rows: 11.916
Number of columns: 5
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.CSS_ID+Q2.SERVICE+Q3.SURV_ID
+Q3.CSS_ID
+Q3.SERVICE

15) From Operator #15

Estimated number of rows:
0.00127058
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q1.SURV_ID(A)+Q1.DEMO_VALUE


Output Streams:
--------------
16) To Operator #6

Estimated number of rows:
0.0151402
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q4.DEMO_VALUE+Q4.CSS_ID

......

***************** Explain for query 2
************************************

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

DB2_VERSION: 09.01.3
SOURCE_NAME: SQLC2F0A
SOURCE_SCHEMA: NULLID
SOURCE_VERSION:
EXPLAIN_TIME: 2008-03-14-11.37.31.565718
EXPLAIN_REQUESTER: USERID

Database Context:
----------------
Parallelism: Intra-Partition Parallelism
CPU Speed: 2.361721e-07
Comm Speed: 100
Buffer Pool size: 1933448
Sort Heap size: 45000
Database Heap size: 32000
Lock List size: 24000
Maximum Lock List: 80
Average Applications: 1
Locks Available: 1228800

Package Context:
---------------
SQL Type: Dynamic
Optimization Level: 5
Blocking: Block All Cursors
Isolation Level: Uncommitted Read



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

Original Statement:
------------------
select avg(demo_value)
from userid.std_demo_data a, userid.data_repository2 c
where a.service = 12 and a.recdate between '09/01/2007' and
'11/01/2007' and
c.surv_id = a.surv_id and quest_id = 36311
group by a.css_id
with ur


Optimized Statement:
-------------------
SELECT (Q4.$C0 / Q4.$C1)
FROM
(SELECT SUM(Q3.$C1), COUNT(*)
FROM
(SELECT Q2.CSS_ID, Q1.DEMO_VALUE
FROM USERID.DATA_REPOSITORY2 AS Q1, USERID.STD_DEMO_DATA AS Q2
WHERE (Q1.QUEST_ID = 36311) AND (Q1.SURV_ID = Q2.SURV_ID) AND
(Q2.RECDATE <= '11/01/2007') AND ('09/01/2007' <=
Q2.RECDATE)
AND (Q2.SERVICE = 12)) AS Q3
GROUP BY Q3.$C0) AS Q4

Access Plan:
-----------
Total Cost: 162471
Query Degree: 8

Rows
RETURN
( 1)
Cost
I/O
|
0.79635
GRPBY
( 2)
162471
92221.9
|
0.79635
LMTQ
( 3)
162471
92221.9
|
0.79635
GRPBY
( 4)
162471
92221.9
|
0.79635
NLJOIN
( 5)
162471
92221.9
/-----------+-----------\
626.762 0.00127058
FETCH FETCH
( 6) ( 8)
148244 22.7119
90340.8 3.00127
/---+---\ /----+----\
626.762 6.8794e+07 0.00127058 2.21331e+09
IXSCAN TABLE: USERID IXSCAN TABLE: USERID
( 7) STD_DEMO_DATA ( 9) DATA_REPOSITORY2
143504 22.7021
89714 3
| |
6.8794e+07 2.21331e+09
INDEX: USERID INDEX: SYSIBM
SFRD2 SQL080313101944640




Extended Diagnostic Information:
--------------------------------

No extended Diagnostic Information for this statment.


Plan Details:
-------------


1) RETURN: (Return Result)
Cumulative Total Cost: 162471
Cumulative CPU Cost: 2.28366e+11
Cumulative I/O Cost: 92221.9
Cumulative Re-Total Cost: 53799.3
Cumulative Re-CPU Cost: 2.27797e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 162471
Estimated Bufferpool Buffers: 92222.9

Arguments:
---------
BLDLEVEL: (Build level)
DB2 v9.1.0.3 : s070914
HEAPUSE : (Maximum Statement Heap Usage)
112 Pages
STMTHEAP: (Statement heap size)
10000

Input Streams:
-------------
12) From Operator #2

Estimated number of rows:
0.79635
Number of columns: 1
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q5.$C0


2) GRPBY : (Group By)
Cumulative Total Cost: 162471
Cumulative CPU Cost: 2.28366e+11
Cumulative I/O Cost: 92221.9
Cumulative Re-Total Cost: 53799.3
Cumulative Re-CPU Cost: 2.27797e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 162471
Estimated Bufferpool Buffers: 92222.9

Arguments:
---------
AGGMODE : (Aggregration Mode)
FINAL
GROUPBYC: (Group By columns)
TRUE
GROUPBYN: (Number of Group By columns)
1
GROUPBYR: (Group By requirement)
1: Q3.CSS_ID
ONEFETCH: (One Fetch flag)
FALSE

Input Streams:
-------------
11) From Operator #3

Estimated number of rows:
0.79635
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q3.CSS_ID(A)+Q3.DEMO_VALUE


Output Streams:
--------------
12) To Operator #1

Estimated number of rows:
0.79635
Number of columns: 1
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q5.$C0


3) TQ : (Table Queue)
Cumulative Total Cost: 162471
Cumulative CPU Cost: 2.28366e+11
Cumulative I/O Cost: 92221.9
Cumulative Re-Total Cost: 53799.3
Cumulative Re-CPU Cost: 2.27797e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 162471
Estimated Bufferpool Buffers: 92222.9

Arguments:
---------
LISTENER: (Listener Table Queue type)
FALSE
SORTKEY : (Sort Key column)
1: Q3.CSS_ID(A)
TQ TYPE : (Table queue type)
LOCAL
TQDEGREE: (Degree of Intra-Partition parallelism)
8
TQMERGE : (Merging Table Queue flag)
TRUE
TQREAD : (Table Queue Read type)
READ AHEAD
UNIQUE : (Uniqueness required flag)
FALSE

Input Streams:
-------------
10) From Operator #4

Estimated number of rows:
0.79635
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q3.CSS_ID(A)+Q3.DEMO_VALUE


Output Streams:
--------------
11) To Operator #2

Estimated number of rows:
0.79635
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q3.CSS_ID(A)+Q3.DEMO_VALUE

4) GRPBY : (Group By)
Cumulative Total Cost: 162471
Cumulative CPU Cost: 2.28366e+11
Cumulative I/O Cost: 92221.9
Cumulative Re-Total Cost: 53799.3
Cumulative Re-CPU Cost: 2.27797e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 162471
Estimated Bufferpool Buffers: 92222.9

Arguments:
---------
AGGMODE : (Aggregration Mode)
PARTIAL
GROUPBYC: (Group By columns)
TRUE
GROUPBYN: (Number of Group By columns)
1
GROUPBYR: (Group By requirement)
1: Q3.CSS_ID
ONEFETCH: (One Fetch flag)
FALSE

Input Streams:
-------------
9) From Operator #5

Estimated number of rows:
0.79635
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q3.CSS_ID(A)+Q3.DEMO_VALUE


Output Streams:
--------------
10) To Operator #3

Estimated number of rows:
0.79635
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q3.CSS_ID(A)+Q3.DEMO_VALUE


5) NLJOIN: (Nested Loop Join)
Cumulative Total Cost: 162471
Cumulative CPU Cost: 2.28366e+11
Cumulative I/O Cost: 92221.9
Cumulative Re-Total Cost: 53799.3
Cumulative Re-CPU Cost: 2.27797e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 162471
Estimated Bufferpool Buffers: 92222.9

Arguments:
---------
EARLYOUT: (Early Out flag)
LEFT
FETCHMAX: (Override for FETCH MAXPAGES)
IGNORE
ISCANMAX: (Override for ISCAN MAXPAGES)
IGNORE

Predicates:
----------
4) Predicate used in Join
Comparison Operator: Equal (=)
Subquery Input Required: No
Filter Factor: 1.45362e-08

Predicate Text:
--------------
(Q1.SURV_ID = Q2.SURV_ID)


Input Streams:
-------------
4) From Operator #6

Estimated number of rows:
626.762
Number of columns: 3
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.CSS_ID(A)+Q2.RECDATE(A)+Q2.SURV_ID

8) From Operator #8

Estimated number of rows:
0.00127058
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q1.SURV_ID(A)+Q1.DEMO_VALUE


Output Streams:
--------------
9) To Operator #4

Estimated number of rows:
0.79635
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q3.CSS_ID(A)+Q3.DEMO_VALUE


6) FETCH : (Fetch)
Cumulative Total Cost: 148244
Cumulative CPU Cost: 2.28341e+11
Cumulative I/O Cost: 90340.8
Cumulative Re-Total Cost: 53794.9
Cumulative Re-CPU Cost: 2.27779e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 259.185
Estimated Bufferpool Buffers: 90341.8

Arguments:
---------
JN INPUT: (Join input leg)
OUTER
MAXPAGES: (Maximum pages for prefetch)
626
PREFETCH: (Type of Prefetch)
NONE
ROWLOCK : (Row Lock intent)
NONE
TABLOCK : (Table Lock intent)
INTENT NONE
TBISOLVL: (Table access Isolation Level)
UNCOMMITTED READ

Input Streams:
-------------
2) From Operator #7

Estimated number of rows:
626.762
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.CSS_ID(A)+Q2.RECDATE(A)

3) From Object USERID.STD_DEMO_DATA

Estimated number of rows: 6.8794e
+07
Number of columns: 1
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.SURV_ID


Output Streams:
--------------
4) To Operator #5

Estimated number of rows:
626.762
Number of columns: 3
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.CSS_ID(A)+Q2.RECDATE(A)+Q2.SURV_ID

7) IXSCAN: (Index Scan)
Cumulative Total Cost: 143504
Cumulative CPU Cost: 2.28332e+11
Cumulative I/O Cost: 89714
Cumulative Re-Total Cost: 53794.8
Cumulative Re-CPU Cost: 2.27778e+11
Cumulative Re-I/O Cost: 0
Cumulative First Row Cost: 251.622
Estimated Bufferpool Buffers: 89715

Arguments:
---------
MAXPAGES: (Maximum pages for prefetch)
88815
PREFETCH: (Type of Prefetch)
SEQUENTIAL
ROWLOCK : (Row Lock intent)
NONE
SCANDIR : (Scan Direction)
FORWARD
SCANGRAN: (Intra-Partition Parallelism Scan
Granularity)
400
SCANTYPE: (Intra-Partition Parallelism Scan Type)
LOCAL PARALLEL
SCANUNIT: (Intra-Partition Parallelism Scan Unit)
ROW
TABLOCK : (Table Lock intent)
INTENT NONE

Predicates:
----------
5) Sargable Predicate
Comparison Operator: Less Than or
Equal (<=)
Subquery Input Required: No
Filter Factor: 0.999452

Predicate Text:
--------------
(Q2.RECDATE <= '11/01/2007')

6) Sargable Predicate
Comparison Operator: Less Than or
Equal (<=)
Subquery Input Required: No
Filter Factor: 0.00101938

Predicate Text:
--------------
('09/01/2007' <= Q2.RECDATE)

7) Sargable Predicate
Comparison Operator: Equal (=)
Subquery Input Required: No
Filter Factor: 0.0192308

Predicate Text:
--------------
(Q2.SERVICE = 12)


Input Streams:
-------------
1) From Object USERID.SFRD2

Estimated number of rows: 6.8794e
+07
Number of columns: 4
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.CSS_ID(A)+Q2.RECDATE(A)+Q2.$RID$
+Q2.SERVICE


Output Streams:
--------------
2) To Operator #6

Estimated number of rows:
626.762
Number of columns: 2
Subquery predicate ID: Not
Applicable

Column Names:
------------
+Q2.CSS_ID(A)+Q2.RECDATE(A)