On Wed, Mar 07, 2001 at 11:24:34AM -0600, will trillich wrote: > here's an EXPLAIN on a VIEW which links a few tables: Can you give us the definition of the VIEW? Also, what kinds of data are you dealing with? Stuff like the # of rows. Are the planner estimate's below reasonable? [...] > okay, there's a ton of sorts and so forth in there that don't > seem to be needed; plus i'm sure i've got indexes on the > linked-to tables, so why the SEQ scans, i dunno. It's using SEQ scans because it thinks they're faster than index scans -- in this case, is the planner incorrect? HTH, Neil -- Neil Conway <[EMAIL PROTECTED]> Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc Encrypted mail welcomed In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move. -- Douglas Adams ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
