From: Mark Volpe <volpe.mark@epamail.epa.gov>
To: Najm Hashmi <najm@mondo-live.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Index scan
Date: Wed, 31 Jan 2001 12:42:01 -0500
Message-ID: <3A784E69.ECCAAB30@epamail.epa.gov> (raw)
References: <3A7996AC.AD99A45B@mondo-live.com>
Since you are selecting all the rows of media, there is no reason to use the
index to do this as it would just slow things down.
Mark
Najm Hashmi wrote:
>
> Hi all,
> I am unable to understand why my inidcies are not used in the query.
> I have following indices:
> index on categories.root
> index on media.category
> unique index on categories.id
> Here is my query :
> mondo=# explain select m.id
> form media m, categories c
> where c.id=m.category and c.root like 'B%';
> NOTICE: QUERY PLAN:
>
> Hash Join (cost=22.55..116.80 rows=11 width=28)
> -> Seq Scan on media m (cost=0.00..60.40 rows=840 width=16)
> -> Hash (cost=22.50..22.50 rows=20 width=12)
> -> Index Scan using cat_id_root on categories c
> (cost=0.00..22.50 rows=20 width=12)
> EXPLAIN
>
> I simply dont understand why it uses seq scan on media.
> Thanks all for your help.
> -Najm
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: volpe.mark@epamail.epa.gov, najm@mondo-live.com
Subject: Re: Index scan
In-Reply-To: <3A784E69.ECCAAB30@epamail.epa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox