Hi Chris,

Index created,

CREATE NONCLUSTERED INDEX [IX_VIEW_IP21] ON [dbo].[RESULT]

(

[SAMPLE_NUMBER] ASC,

[STATUS] ASC,

[ANALYSIS] ASC

)

INCLUDE ( [UNITS],

[NAME],

[NUMERIC_ENTRY]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO

But actucal exec.plan high seek 94% which created new index on that table...

could we remove that new index?

thanks