Congratulations. That is the largest plan I have ever seen. ;-)
--------------------------------------------------------------------------- Kris Jurka wrote: > While adding schema support to the JDBC Driver, I came across a query > which occasionally generates some spectacularly bad plans. I have > attached the query and explain analyze outputs against today's cvs head > for queries that take between 9 and 845941 msec. In the JDBC Driver I > will specify a reasonable join order using explicit JOINs, but I thought > someone might be interested in a test case for the optimizer. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
