======================================================
11/25/08 reworked proc results
======================================================


QUERY PLAN FOR STATEMENT 1 (at line 1).	   
	   
	   
    STEP 1	   
        The type of query is EXECUTE.	   
	   
Parse and Compile Time 0.	   
SQL Server cpu time: 0 ms.	   
	   
QUERY PLAN FOR STATEMENT 1 (at line 0).	   
	   
	   
    STEP 1	   
        The type of query is DECLARE.	   
	   
	   
QUERY PLAN FOR STATEMENT 2 (at line 16).	   
	   
	   
    STEP 1	   
        The type of query is CREATE TABLE.	   
	   
	   
QUERY PLAN FOR STATEMENT 3 (at line 19).	   
	   
	   
    STEP 1	   
        The type of query is SELECT.	   
	   
	   
QUERY PLAN FOR STATEMENT 4 (at line 20).	   
	   
	   
    STEP 1	   
        The type of query is SELECT (into Worktable1).	   
        GROUP BY	   
        Evaluate Grouped COUNT AGGREGATE.	   
	   
        FROM TABLE	   
            Inspection	   
            I	   
        Nested iteration.	   
        Index : iNC_Inspection_DW	   
        Forward scan.	   
        Positioning at index start.	   
        Index contains all needed columns. Base table will not be read.	   
        Using I/O Size 2 Kbytes for index leaf pages.	   
        With LRU Buffer Replacement Strategy for index leaf pages.	   
	   
        FROM TABLE	   
            Inspection_Part	   
            IP	   
        Nested iteration.	   
        Using Clustered Index.	   
        Index : pkc_Inspection_Part	   
        Forward scan.	   
        Positioning by key.	   
        Keys are:	   
            Inspection_ID  ASC	   
        Using I/O Size 2 Kbytes for data pages.	   
        With LRU Buffer Replacement Strategy for data pages.	   
        TO TABLE	   
            Worktable1.	   
	   
    STEP 2	   
        The type of query is INSERT.	   
        The update mode is direct.	   
	   
        FROM TABLE	   
            Worktable1.	   
        Nested iteration.	   
        Table Scan.	   
        Forward scan.	   
        Positioning at start of table.	   
        Using I/O Size 2 Kbytes for data pages.	   
        With MRU Buffer Replacement Strategy for data pages.	   
        TO TABLE	   
            #temp_insp_part_count	   
        Using I/O Size 2 Kbytes for data pages.	   
	   
	   
QUERY PLAN FOR STATEMENT 5 (at line 43).	   
	   
	   
    STEP 1	   
        The type of query is SELECT.	   
	   
        FROM TABLE	   
            #temp_insp_part_count	   
        Nested iteration.	   
        Table Scan.	   
        Forward scan.	   
        Positioning at start of table.	   
        Using I/O Size 2 Kbytes for data pages.	   
        With MRU Buffer Replacement Strategy for data pages.	   
	   
Parse and Compile Time 0.	   
SQL Server cpu time: 0 ms.	   
Total writes for this command: 0	   
 	   
Execution Time 0.	   
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 16 ms.	   
Total writes for this command: 0	   
 	   
Execution Time 0.	   
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.	   
Table: #temp_insp_pa01017600009551500 scan count 0, logical reads: (regular=2322 apf=0 total=2322), physical reads: (regular=2 apf=0 total=2), apf IOs used=0	   
Table: Inspection scan count 1, logical reads: (regular=1124918 apf=0 total=1124918), physical reads: (regular=457772 apf=680356 total=1138128), apf IOs used=667146	   
Table: Inspection_Part scan count 2296, logical reads: (regular=9279 apf=0 total=9279), physical reads: (regular=86 apf=31 total=117), apf IOs used=26	   
Table: Worktable1  scan count 1, logical reads: (regular=4668 apf=0 total=4668), physical reads: (regular=3 apf=0 total=3), apf IOs used=0	   
Total writes for this command: 8	   
 	   
Execution Time 304.	   
SQL Server cpu time: 30400 ms.  SQL Server elapsed time: 161236 ms.