FROM TABLE
xxx..aaaaa
a
Nested iteration.
Index : aaaaa1
Forward scan.
Positioning at index start.
Using I/O Size 8 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 8 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
------------------------------------------------------------------------
FROM TABLE
xxx..aaaaa
a
Nested iteration.
Index : aaaaa1
Forward scan.
Positioning by key.
Keys are:
borntime ASC
Using I/O Size 8 Kbytes for index leaf pages.
With LRU Buffer Replacement Strategy for index leaf pages.
Using I/O Size 8 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
두개 플랜의 차이가 무엇인가요.??
쿼리상의 차이는 borntime 이 nonclustered index로 잡혀있는대
위의 쿼리는 borntime between convert(date, '20070801') and convert(date, '20070831') 로 했고요
아래의 쿼리는 borntime between convert(datetime, '20070801'+' 00:00:00') and convert(datetime, '20070831'+' 23:59:59') 이 차이뿐입니다.
두개의 플랜의 차이와 속도차이가 있나요?
그럼 수고하세요~~~ 화이팅...~!!!
|