Change the order of the keys - this should give you seeks on [status];
CREATE NONCLUSTERED INDEX [IX_VIEW_IP21] ON [dbo].[RESULT]
(
[STATUS] ASC,
[SAMPLE_NUMBER] 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
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden