Tim Perdue <tperdue@valinux.com> writes:
> I added the suggested index and changed my sql and the subjective tests
> seem to be improved somewhat. I checked EXPLAIN and it is using the new
> index.
> I still think there must be sorting going on, as the result is returned
> instantly if you remove the ORDER BY.
You "think"? What does EXPLAIN show in the two cases?
regards, tom lane