SQL Server 실행 시간:
CPU 시간 = 297ms, 경과 시간 = 26997ms.
(162811개 행 적용됨)
test_tableB 실행값
SQL Server 실행 시간:
CPU 시간 = 203ms, 경과 시간 = 25781ms.
--------- profile 결과 -----------
[test_tableA] 결과
160397 1 SELECT * FROM [test_tableA] WHERE [seq]>@1 19 1 0 NULL NULL NULL NULL 160397.0 NULL NULL NULL 1.4603649 NULL NULL SELECT 0 NULL
160397 1 |--Clustered Index Seek(OBJECT:([testdb].[testdb].[test_table].[PK_test_table]), SEEK:([test_table].[seq] > Convert([@1])) ORDERED FORWARD)
19
3
1
Clustered Index Seek
Clustered Index Seek
OBJECT:([testdb].[testdb].[test_table].[PK_test_tableA]), SEEK:([test_table].[seq] > Convert([@1])) ORDERED FORWARD
[test_table].[iSubCnt], [test_table].[point], [test_table].[level_pass], [test_table].[book_pass], [test_table].[jisa_id], [test_table].[number], [test_table].[book_gubun], [test_table].[book_code], [test_table].[write_date], [test_table].[book_level], [te
160397.0
1.26781
0.17651521
95
1.4443252
[test_table].[iSubCnt], [test_table].[point], [test_tableA].[level_pass], [test_table].[book_pass], [test_table].[jisa_id], [test_table].[number], [test_table].[book_gubun], [test_table].[book_code], [test_table].[write_date], [test_table].[book_level], [te
NULL
PLAN_ROW
0
1.0
[test_tableB] 결과
162811 1 SELECT * FROM [test_tableB] 20 1 0 NULL NULL NULL NULL 162765.0 NULL NULL NULL 1.5018638 NULL NULL SELECT 0 NULL
162811 1 |--Table Scan(OBJECT:([testdb].[dbo].[test_tableB]))
20
3
1
Table Scan
Table Scan OBJECT:([testdb].[dbo].[test_tableB])
[test_tableB].[iSubCnt], [test_tableB].[point], [test_tableB].[level_pass], [test_tableB].[book_pass], [test_tableB].[jisa_id], [test_tableB].[number], [test_tableB].[book_gubun], [test_tableB].[book_code], [test_tableB].[write_d
162765.0
1.3064674
0.17912
102
1.4855874
[test_tableB].[iSubCnt], [test_tableB].[point], [test_tableB].[level_pass], [test_tableB].[book_pass], [test_tableB].[jisa_id], [test_tableB].[number], [test_tableB].[book_gubun], [test_tableB].[book_code], [test_tableB].[write_d
NULL
PLAN_ROW
0
1.0
-------------------------------
참고로 한 20만 row 데이터 select 시 어는정도 시간걸리나염?