index 생성 조회 삭제

 

 

인덱스 생성

CREATE INDEX [인덱스명] ON [테이블명] ([컬럼명] [정렬방식])

CREATE INDEX ix_shpbarcod   ON tbl_workdetail (shpbarcod asc)

 

인덱스 조회

sp_helpindex [테이블명]

sp_helpindex 'tbl_workdetail'

 

SELECT * FROM sys.indexes WHERE NAME = [인덱스명]

SELECT * FROM sys.indexes WHERE NAME = 'ix_PDA_SALEDTL_1'

SELECT * FROM sys.indexes a left join sys.sysobjects b on a.object_id = b.id WHERE
a.is_unique = 0 and
a.name is not null and
b.name = [테이블명]

SELECT * FROM sys.indexes a left join sys.sysobjects b on a.object_id = b.id WHERE
a.is_unique = 0 and
a.name is not null and
b.name = 'tbl_workdetail'

 

인덱스 삭제 

drop index [인덱스명] on [테이블명]

 

drop index ix_shpbarcod on tbl_workdetail