MSSQL 2005 관리자 강좌_7일차

* covering index

-- 2005 부터 지원. 마지막 노드에서만 col2 를 포함

create index ix_tbl1 on tbl (col1) include (col2)

nonclustered : ix_tblname

clustered : cx_tblname

create [unique]

[clustered] [nonclustered]

index ix_tblname

order by col1 asc, col2 desc

include ()  -- in sql2005

where   -- in sql2008

create index ix_xxxx on table (col)

where col <> 0

* 정밀한 실행 계획

-- trace flag 2301

* 인덱스 확인

sp_help tbl_name

sp_helpindex tbl_name

-- two : 2005 : include, where 내용이 없음 

sp_helpindex2 tblname

select * from sys.dm_db_index_usage_stats;

select db_name(1)

select db_name(database_id), object_name(object_id), *

from sys.dm_db_index_usage_stats;

* 라이선스 정책

-- CAL : USER

-- PROCESSOR : socket (core x) : web

-- sql 2008 R2 : data center