Help with performance

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


--
lp,
 Uros                          mailto:uros.gruber@sir-mag.com