(index 인덱스)
하면 인덱스를 정방향으로 타는데
반대방향으로 탈수는 없나요
방법좀 알려주세요
테스트 >>
pubs2의 titles라는 테이블에 nonclustered index를 생성
create nonclustered index idx_1 on titles(advance)
** index forward scan
select * from titles (index idx_1)
query plan]
STEP 1 The type of query is SELECT.
FROM TABLE titles Nested iteration. Index : idx_1 Forward scan. Positioning at index start.
** index backward scan
select * from titles (index idx_1) order by advance desc
FROM TABLE titles Nested iteration. Index : idx_1 Backward scan. Positioning at index end.