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