That does work and causes a seek on the nonclustered index. However, as soon as I add another field to the select then I am back to a scan.
I do not need all the columns when I am doing the select.
I would get the Clustered Index Scan even if I had this as the query:
I have the following table:
CREATE TABLE [dbo].[POLICIES](
[policy_id] [int] NOT NULL,
[row_begin_date] [datetime] NOT NULL,
Separate names with a comma.