| From: | Najm Hashmi <najm(at)mondo-live(dot)com> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Index scan |
| Date: | 2001-02-01 17:02:36 |
| Message-ID: | 3A7996AC.AD99A45B@mondo-live.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | guard | 2001-02-01 18:01:45 | how to simulate UPdate ...? |
| Previous Message | Brice Ruth | 2001-02-01 16:56:36 | SQL Join - MySQL/PostgreSQL difference? |