Paul, adding the ORDER BY boosted the query times !

I'm adding the plans Before and After. Before (The original Jeff's query) took like 1 minutes and the After was instant.

I'm...

Dear Barry, the exec plan for your suggestion is the same as NewExec I just posted.

The approach is ok, but it's making a clust-ix-scan that scans through the first 15.000...

I double posted by mistake, sorry.

Here are all the plans in the attached zip.

Barry, I'm posting the actual exec plan (named Old_Exec) which is the plan before I implemented latest Paul's suggestion (a non clust ix).

I implemented Paul's suggestion. I added the non...

Barry, I'm posting the actual exec plan (named Old_Exec) which is the plan before I implemented latest Paul's suggestion (a non clust ix).

I implemented Paul's suggestion. I added the non...

Barry:

I'm posting a different plan, the one for the query suggested by Jeff.

What I meant originally is that it takes a lot to retrieve at the position 30.000, but due...