On Fri, 18 Feb 2005, Keith Worthington wrote:
> I have been working on a SQL statement that contains a WHERE clause of the
> form WHERE column1 > column2. The query runs pretty quickly (285ms) without
> the WHERE clause but slows to a relative crawl (5850ms) when it is included.
> Anu suggestions on how to improve the performance would be greatly appreciated.
Explain analyze output for the query with and without the clause would
probably be useful for analysis.