Facing a pocket pair

[BillGatesIII]

Here it takes less than ten seconds to run on a 8486MB database

[andrewy01]

Strange - maybe I'll do the db housekeeping and try again. Thanks for your help

[kraada]

Make sure you do a REINDEX -- this kind of thing could be a symptom of a corrupted index. In fact, I'd try that first -- it's shorter than the other housekeeping functions and might be all you need.