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 <neilconway@home.com>
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