OK, I ran the query on a "shadow" database (to avoid impacting my online users...) and it ran correctly and in five seconds. So, there must be some other issue. My users are live now, and seem to be having few issues. Assuming I've got a corrupted index or something, what should I try first (after kicking them off for the day...)? I keep 20 daily backuips, and I reorganize and truncate each night. It's a small standalone DB, and not used at night.

What's the strategy?

(PS...shadow db is a "detach and copy" of the main db. I made it yesterday...)