dbo.pdc.pdc_filename

Object Type	Index
Datasource	IPMA
Database	icsa

Properties

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

Columns

NAME

filename

DDL

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