In case this helps someone else someday:

I created a clustered index on MYID and MYFIELD2 and regained the speed I had before adding the WHERE filter.

Janet

Thanks for the reply, John. I tried your suggestion re: Top_N_Rank, with no noticeable improvement in performance.

I doubt I'm running into the bugs you mention -- at least not...