Re: explain -> how to optimize?

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