On Tue, 30 Sep 2003, Oleg Lebedev wrote:
> I continue struggling with the TPC-R benchmarks and wonder if anyone
> could help me optimize the query below. ANALYZE statistics indicate that
> the query should run relatively fast, but it takes hours to complete. I
> attached the query plan to this posting.
> Thanks.
What are the differences between estimated and real rows and such of an
explain analyze on that query? Are there any estimates that are just way
off?