From: | Uros Gruber <uros(dot)gruber(at)sir-mag(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Help with performance |
Date: | 2002-04-24 20:49:12 |
Message-ID: | 85107633618.20020424224912@sir-mag.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)gruber(at)sir-mag(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Uros Gruber | 2002-04-24 20:51:25 | Help with performance - No2 |
Previous Message | Justin Clift | 2002-04-24 20:42:31 | Re: scrambled data / security |