Hi!
I have 2 tables
\d table1
Column | Type
----------------+--------------------------
id_entry | integer
created | timestamp with time zone
title | character varying(64)
description | text
Primary key: table1_pk
Index "table1_pk"
Column | Type
----------+---------
id_entry | integer
unique btree (primary key)
\d table2
Column | Type
-------------+-----------------------
id_category | character varying(64)
id_entry | character varying(64)
Primary key: table2_pk
\d table2_pk
Column | Type
-------------+-----------------------
id_category | character varying(64)
id_entry | character varying(64)
unique btree (primary key)
Not i have query like this
select d.title from table1 d, table2 c where c.id_category='09' and d.id_entry=c.id_entry;
This is query plan
NOTICE: QUERY PLAN:
Nested Loop (cost=0.00..154844.08 rows=96 width=36)
-> Seq Scan on table1 d (cost=0.00..2957.36 rows=25236 width=28)
-> Index Scan using table1_pk on table2 c (cost=0.00..6.00 rows=1 width=8)
I see that there is seq scan over 25k rows, how can i set
indexes to make query faster and use indexes.
--
lp,
Uros mailto:uros.gruber@sir-mag.com