From: Objectz <objectz@postmark.net>
To: pgsql-sql@postgresql.org
Subject: Execution plan Question
Date: Mon, 10 Mar 2003 18:43:17 +0200
Message-ID: <002201c2e724$2816d8a0$aea067d4@eg1opwxp107> (raw)
hi all,
I have a strange problem and really wish to get some help in here.
I have the following tables
create table shr_objects(
objectid int8 not null
companyid int4 not null
name varchar(255)
description varchar(255)
)
primary key : object id
foreign key on companyid references shr_companies(companyid)
Index on companyid
Number of rows ~ 1,410,000
create table smb_contacts{
contactid int4 not null
objectid int8 not null
firstname varchar(255)
lastname varchar(255)
)
primary key : contactid
foreign key on objectid references shr_objects9objectid)
index on : objectid
Number of rows ~ 10,000
I am trying to execute a query that joins the 2 tables on object id , it
works fine but when i add an order clause the performance is degarded
dramatically. I have included both quiries with their excution plan.
Regards,
--ObjectZ Maker
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: objectz@postmark.net
Subject: Re: Execution plan Question
In-Reply-To: <002201c2e724$2816d8a0$aea067d4@eg1opwxp107>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox