@pavan_srirangam The query is using the correct index as I've already verified that by viewing the execution plan.

Finally figured it out. It's like this:

exec sp_create_plan_guide

@name = N'TestPlanGuide1',

@stmt = N'SELECT top 1000 ColumnName FROM [DBName].[dbo].[TableName] with (nolock)

WHERE (ColumnName < Criteria)',

@type = N'SQL',

@module_or_batch = NULL,

@params =...

Hi Bruce,

I know that's an alternative but I was wondering if there is a way to skip that step & just insert the output into a table directly...even when I'm...

bvaljalo,

Thanks for the links. Unfortunately, I already read those articles but I appreciate your help.

Jeff,

The target table does already exist. I have tried running insert but...