MSSQL 2005 관리자 강좌_8일차
2010. 12. 9.
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_no, count(*) from c group by statement_no select member_no, count(*) from c group by member_no select min(charge_dt), ..