dbo.pdc.pdc_ux

Object Type	Index
Datasource	IPMA
Database	icsa

Properties

Unique	Yes
Cluster	No
Ignore Duplicate Keys	No
Non-Unique Options
Ignore Duplicate Rows	No
Allow Duplicate Rows	No

Columns

NAME

obsno

filename

DDL

CREATE UNIQUE NONCLUSTERED INDEX pdc_ux
    ON dbo.pdc(obsno,filename)
  WITH FILLFACTOR = 100
go
EXEC sp_cachestrategy 'icsa','dbo.pdc','pdc_ux','mru','off'
go