dbo.observations.observations_ix3

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

obsno

prodqlty

aotname

DDL

CREATE NONCLUSTERED INDEX observations_ix3
    ON dbo.observations(obsno,prodqlty,aotname)
go