DECLARE     @f_user  int
   set         @f_user =  6  

   DELETE FROM w_getdate
   INSERT INTO w_getdate   SELECT  1 , GetDate (), DATEDIFF(ms,Max (date_time),GetDate ()) FROM w_getdate
   /* всегда работает моментально! */
   SELECT
           f_sum.f_sum
   FROM
           l_dealuser,
           f_sum
   WHERE
           l_dealuser.f_deal = f_sum.f_deal AND
           l_dealuser.f_user =  6 

   INSERT INTO w_getdate   SELECT  2 , GetDate (), DATEDIFF(ms,Max (date_time),GetDate ()) FROM w_getdate
   
   /* Висит всегда две с плоловиной секунды ! */   
   /*  Нужно чтобы эта выборка работала!!!! */
   SELECT
           f_sum.f_sum
   FROM
           l_dealuser,
           f_sum
   WHERE
           l_dealuser.f_deal = f_sum.f_deal AND
           l_dealuser.f_user = @f_user
           
   /******************************************************************************/
           
   INSERT INTO w_getdate   SELECT  3 , GetDate (), DATEDIFF(ms,Max (date_time),GetDate ()) FROM w_getdate
   
   /* всегда работает моментально! */
   SELECT
           f_sum.f_deal
   FROM
           l_dealuser,
           f_sum
   WHERE
           l_dealuser.f_deal = f_sum.f_deal AND
           l_dealuser.f_user =  6 
           
   INSERT INTO w_getdate   SELECT  3 , GetDate (), DATEDIFF(ms,Max (date_time),GetDate ()) FROM w_getdate
   
   /* всегда работает моментально! */
   SELECT
           f_sum.f_deal
   FROM
           l_dealuser,
           f_sum
   WHERE
           l_dealuser.f_deal = f_sum.f_deal AND
           l_dealuser.f_user = @f_user

   INSERT INTO w_getdate   SELECT  4 , GetDate (), DATEDIFF(ms,Max (date_time),GetDate ()) FROM w_getdate

   /* повтор второго  */
   /* Висит всегда две с плоловиной секунды ! */   
   /*  Нужно чтобы эта выборка работала!!!! */
   SELECT
           f_sum.f_sum
   FROM
           l_dealuser,
           f_sum
   WHERE
           l_dealuser.f_deal = f_sum.f_deal AND
           l_dealuser.f_user = @f_user

   INSERT INTO w_getdate   SELECT  5 , GetDate (), DATEDIFF(ms,Max (date_time),GetDate ()) FROM w_getdate

   SELECT * FROM w_getdate   
   
/*   
   /* Результат выборки!!! */
A	B	C
f_sum		
 118076828 		
 118076829 		
 118076830 		
 118076835 		
 118076836 		
 118076837 		
 118076838 		
 118076839 		
 118076840 		
 118076841 		
 118076842 		
 118076843 		
 118077536 		
 118077537 		
 118077538 		
 118077539 		
 118077540 		
 118077541 		
 118077548 		
 118077550 		
 118077549 		
 118077552 		
 118077551 		
 118077553 		
		
f_sum		
 118076828 		
 118076829 		
 118076830 		
 118076835 		
 118076836 		
 118076837 		
 118076838 		
 118076839 		
 118076840 		
 118076841 		
 118076842 		
 118076843 		
 118077548 		
 118077550 		
 118077552 		
 118077549 		
 118077551 		
 118077553 		
 118077536 		
 118077537 		
 118077538 		
 118077539 		
 118077540 		
 118077541 		
		
f_deal		
 40667661 		
 40667661 		
 40667661 		
 40667663 		
 40667663 		
 40667663 		
 40667664 		
 40667664 		
 40667664 		
 40667665 		
 40667665 		
 40667665 		
 40667699 		
 40667699 		
 40667699 		
 40667700 		
 40667700 		
 40667700 		
 40667703 		
 40667703 		
 40667703 		
 40667704 		
 40667704 		
 40667704 		
		
f_deal		
 40667661 		
 40667661 		
 40667661 		
 40667663 		
 40667663 		
 40667663 		
 40667664 		
 40667664 		
 40667664 		
 40667665 		
 40667665 		
 40667665 		
 40667699 		
 40667699 		
 40667699 		
 40667700 		
 40667700 		
 40667700 		
 40667703 		
 40667703 		
 40667703 		
 40667704 		
 40667704 		
 40667704 		
		
f_sum		
 118076828 		
 118076829 		
 118076830 		
 118076835 		
 118076836 		
 118076837 		
 118076838 		
 118076839 		
 118076840 		
 118076841 		
 118076842 		
 118076843 		
 118077548 		
 118077550 		
 118077552 		
 118077549 		
 118077551 		
 118077553 		
 118077536 		
 118077537 		
 118077538 		
 118077539 		
 118077540 		
 118077541 		
		
num	date_time	sec
 1 	 29 . 01 . 2009   17 : 27 : 19 . 873 	[NULL]
 2 	 29 . 01 . 2009   17 : 27 : 19 . 873 	 0 
 3 	 29 . 01 . 2009   17 : 27 : 22 . 733 	 2860 
 3 	 29 . 01 . 2009   17 : 27 : 22 . 733 	 0 
 4 	 29 . 01 . 2009   17 : 27 : 22 . 733 	 0 
 5 	 29 . 01 . 2009   17 : 27 : 25 . 450 	 2716 

 **/ 
  
/* Таблици */ 
/*
CREATE TABLE dbo.f_sum 
(
    f_sum       int           NOT NULL,
    f_deal      int           NULL,
    f_sumtype   int           NULL,
    c_sumkind   int           NULL,
    c_currency  int           NULL,
    f_account   int           NULL,
    stat        int           NULL,
    date_time   datetime      NULL,
    date_pay    datetime      NULL,
    value       decimal(18,6) NULL,
    value_pay   decimal(18,6) NULL,
    name        varchar(30)   NULL,
    unlimited   int           NULL,
    dt_modify   datetime      NULL,
    user_modify varchar(30)   NULL,
    rate        decimal(18,6) NULL,
    procent     decimal(18,6) NULL,
    f_user      int           NULL,
    CONSTRAINT pk_f_sum
    PRIMARY KEY CLUSTERED (f_sum),
CONSTRAINT fk_f_sum_sum_curre_c_curren
    FOREIGN KEY (c_currency)
    REFERENCES dbo.c_currency (c_currency),
CONSTRAINT fk_f_sum_sum_kind_c_sumkin
    FOREIGN KEY (c_sumkind)
    REFERENCES dbo.c_sumkind (c_sumkind),
CONSTRAINT fk_f_sum_sum_deal_f_deal
    FOREIGN KEY (f_deal)
    REFERENCES dbo.f_deal (f_deal),
CONSTRAINT fk_f_sum_sum_acc_f_accoun
    FOREIGN KEY (f_account)
    REFERENCES dbo.f_account (f_account),
CONSTRAINT fk_f_sum_sum_user_f_user
    FOREIGN KEY (f_user)
    REFERENCES dbo.f_user (f_user),
CONSTRAINT fk_f_sum_sum_type_f_sumtyp
    FOREIGN KEY (f_sumtype)
    REFERENCES dbo.f_sumtype (f_sumtype)
)
LOCK DATAPAGES


CREATE TABLE dbo.l_dealuser 
(
    l_dealuser int NOT NULL,
    f_deal     int NULL,
    f_user     int NULL,
    CONSTRAINT pk_l_dealuser
    PRIMARY KEY CLUSTERED (l_dealuser),
CONSTRAINT fk_l_dealus_deus_deal_f_deal
    FOREIGN KEY (f_deal)
    REFERENCES dbo.f_deal (f_deal),
CONSTRAINT fk_l_dealus_deus_user_f_user
    FOREIGN KEY (f_user)
    REFERENCES dbo.f_user (f_user)
)
LOCK DATAPAGES

CREATE TABLE dbo.w_getdate 
(
    num       int      NULL,
    date_time datetime NULL,
    sec       int      NULL
)

Select @@version 
Adaptive Server Enterprise/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS 4.0/ase1251/1838/32-bit/OPT/Fri Feb 20 04:11:31 2004

SELECT Count (*) FROM l_dealuser 
498

SELECT Count (*) FROM f_sum
732473

*/
  
/* Получение плана и статистику по SQL запросу для следующих команд */
/*
set showplan on
set statistics io on
set statistics time on
go
  
A

Total writes for this command: 0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 190 ms.
QUERY PLAN FOR STATEMENT 1 (at line 2). 
STEP 1 
The type of query is DECLARE. 
QUERY PLAN FOR STATEMENT 2 (at line 3). 
STEP 1 
The type of query is SELECT. 
QUERY PLAN FOR STATEMENT 3 (at line 5). 
STEP 1 
The type of query is DELETE. 
The update mode is direct. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 4 (at line 6). 
STEP 1 
The type of query is SELECT. 
Evaluate Ungrouped MAXIMUM AGGREGATE. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
STEP 2 
The type of query is INSERT. 
The update mode is deferred. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 5 (at line 8). 
STEP 1 
The type of query is SELECT. 
FROM TABLE 
l_dealuser 
Nested iteration. 
Index : deus_user 
Forward scan. 
Positioning by key. 
Keys are: 
f_user  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
FROM TABLE 
f_sum 
Nested iteration. 
Index : sum_deal 
Forward scan. 
Positioning by key. 
Keys are: 
f_deal  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
QUERY PLAN FOR STATEMENT 6 (at line 17). 
STEP 1 
The type of query is SELECT. 
Evaluate Ungrouped MAXIMUM AGGREGATE. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
STEP 2 
The type of query is INSERT. 
The update mode is deferred. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 7 (at line 21). 
STEP 1 
The type of query is INSERT. 
The update mode is direct. 
Worktable1 created for REFORMATTING. 
FROM TABLE 
l_dealuser 
Nested iteration. 
Index : deus_user 
Forward scan. 
Positioning by key. 
Keys are: 
f_user  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
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 SELECT. 
FROM TABLE 
f_sum 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
FROM TABLE 
Worktable1. 
Nested iteration. 
Using Clustered Index. 
Forward scan. 
Positioning by key. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
QUERY PLAN FOR STATEMENT 8 (at line 32). 
STEP 1 
The type of query is SELECT. 
Evaluate Ungrouped MAXIMUM AGGREGATE. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
STEP 2 
The type of query is INSERT. 
The update mode is deferred. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 9 (at line 35). 
STEP 1 
The type of query is SELECT. 
FROM TABLE 
l_dealuser 
Nested iteration. 
Index : deus_user 
Forward scan. 
Positioning by key. 
Keys are: 
f_user  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
FROM TABLE 
f_sum 
Nested iteration. 
Index : sum_deal 
Forward scan. 
Positioning by key. 
Index contains all needed columns. Base table will not be read. 
Keys are: 
f_deal  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
QUERY PLAN FOR STATEMENT 10 (at line 44). 
STEP 1 
The type of query is SELECT. 
Evaluate Ungrouped MAXIMUM AGGREGATE. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
STEP 2 
The type of query is INSERT. 
The update mode is deferred. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 11 (at line 47). 
STEP 1 
The type of query is SELECT. 
FROM TABLE 
l_dealuser 
Nested iteration. 
Index : deus_user 
Forward scan. 
Positioning by key. 
Keys are: 
f_user  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
FROM TABLE 
f_sum 
Nested iteration. 
Index : sum_deal 
Forward scan. 
Positioning by key. 
Index contains all needed columns. Base table will not be read. 
Keys are: 
f_deal  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
QUERY PLAN FOR STATEMENT 12 (at line 56). 
STEP 1 
The type of query is SELECT. 
Evaluate Ungrouped MAXIMUM AGGREGATE. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
STEP 2 
The type of query is INSERT. 
The update mode is deferred. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 13 (at line 61). 
STEP 1 
The type of query is INSERT. 
The update mode is direct. 
Worktable1 created for REFORMATTING. 
FROM TABLE 
l_dealuser 
Nested iteration. 
Index : deus_user 
Forward scan. 
Positioning by key. 
Keys are: 
f_user  ASC 
Using I/O Size 2 Kbytes for index leaf pages. 
With LRU Buffer Replacement Strategy for index leaf pages. 
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 SELECT. 
FROM TABLE 
f_sum 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
FROM TABLE 
Worktable1. 
Nested iteration. 
Using Clustered Index. 
Forward scan. 
Positioning by key. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
QUERY PLAN FOR STATEMENT 14 (at line 70). 
STEP 1 
The type of query is SELECT. 
Evaluate Ungrouped MAXIMUM AGGREGATE. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
STEP 2 
The type of query is INSERT. 
The update mode is deferred. 
TO TABLE 
w_getdate 
Using I/O Size 2 Kbytes for data pages. 
QUERY PLAN FOR STATEMENT 15 (at line 72). 
STEP 1 
The type of query is SELECT. 
FROM TABLE 
w_getdate 
Nested iteration. 
Table Scan. 
Forward scan. 
Positioning at start of table. 
Using I/O Size 2 Kbytes for data pages. 
With LRU Buffer Replacement Strategy for data pages. 
Parse and Compile Time 1. 
SQL Server cpu time: 100 ms.
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Table: w_getdate scan count 0, logical reads: (regular=0 apf=0 total=0), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Table: w_getdate scan count 0, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.

f_sum
118076828
118076829
118076830
118076835
118076836
118076837
118076838
118076839
118076840
118076841
118076842
118076843
118077536
118077537
118077538
118077539
118077540
118077541
118077548
118077550
118077549
118077552
118077551
118077553
Table: l_dealuser scan count 1, logical reads: (regular=4 apf=0 total=4), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: f_sum scan count 8, logical reads: (regular=21 apf=0 total=21), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Table: w_getdate scan count 0, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
The sort for Worktable1 is done in Serial   

f_sum
118076828
118076829
118076830
118076835
118076836
118076837
118076838
118076839
118076840
118076841
118076842
118076843
118077548
118077550
118077552
118077549
118077551
118077553
118077536
118077537
118077538
118077539
118077540
118077541
Table: l_dealuser scan count 1, logical reads: (regular=4 apf=0 total=4), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: f_sum scan count 1, logical reads: (regular=74476 apf=0 total=74476), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: Worktable1  scan count 624542, logical reads: (regular=1249110 apf=0 total=1249110), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 114 
Execution Time 28. 
SQL Server cpu time: 2800 ms.  SQL Server elapsed time: 2840 ms.
Table: w_getdate scan count 0, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.

f_deal
40667661
40667661
40667661
40667663
40667663
40667663
40667664
40667664
40667664
40667665
40667665
40667665
40667699
40667699
40667699
40667700
40667700
40667700
40667703
40667703
40667703
40667704
40667704
40667704
Table: l_dealuser scan count 1, logical reads: (regular=4 apf=0 total=4), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: f_sum scan count 8, logical reads: (regular=10 apf=0 total=10), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Table: w_getdate scan count 0, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.

f_deal
40667661
40667661
40667661
40667663
40667663
40667663
40667664
40667664
40667664
40667665
40667665
40667665
40667699
40667699
40667699
40667700
40667700
40667700
40667703
40667703
40667703
40667704
40667704
40667704
Table: l_dealuser scan count 1, logical reads: (regular=4 apf=0 total=4), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: f_sum scan count 8, logical reads: (regular=10 apf=0 total=10), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
Table: w_getdate scan count 0, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.
The sort for Worktable1 is done in Serial   

f_sum
118076828
118076829
118076830
118076835
118076836
118076837
118076838
118076839
118076840
118076841
118076842
118076843
118077548
118077550
118077552
118077549
118077551
118077553
118077536
118077537
118077538
118077539
118077540
118077541
Table: l_dealuser scan count 1, logical reads: (regular=4 apf=0 total=4), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: f_sum scan count 1, logical reads: (regular=74476 apf=0 total=74476), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: Worktable1  scan count 624542, logical reads: (regular=1249110 apf=0 total=1249110), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 95 
Execution Time 27. 
SQL Server cpu time: 2700 ms.  SQL Server elapsed time: 2720 ms.
Table: w_getdate scan count 0, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.

num
1
2
3
3
4
5
Table: w_getdate scan count 1, logical reads: (regular=1 apf=0 total=1), physical reads: (regular=0 apf=0 total=0), apf IOs used=0 
Total writes for this command: 0 
Execution Time 0. 
SQL Server cpu time: 0 ms.  SQL Server elapsed time: 0 ms.

*/