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. Would I...
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: select policy_id...
I have the following table: CREATE TABLE [dbo].[POLICIES]( [policy_id] [int] NOT NULL, [row_begin_date] [datetime] NOT NULL, [row_end_date]...
Separate names with a comma.
