MSSQL 2005 관리자 강좌_8일차

sp_helpindex charge

create index charge_member_link

on charge (member_no, charge_dt, charge_amt)

with drop_existing

-- 2005 에서 지원하는 include 이용

create index charge_member_link2

on charge (member_no, charge_dt )

include (charge_amt)

-- create, drop

-- 1.cx

-- 2.nx

select statement_n

인덱스.zip

o, count(*)

from c

group by statement_no

select member_no, count(*)

from c

group by member_no

select min(charge_dt), max(charge_dt)

from c

create clustered index cx_c

on c (member_no)