Don't look at any of the statistics until you've worked out where the time is going, or where the majority of the work is happening. It's very easy to get distracted by something, the pattern that you've seen before. In a big enough query, a scan of even a few hundred thousand rows might be the especially if it's returning most of them may be optimal. Missindx orngapisaa exactly.