From: | "Chad Thompson" <chad(at)weblinkservices(dot)com> |
---|---|
To: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>, <josh(at)agliodbs(dot)com>, "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Simple but slow |
Date: | 2002-08-22 15:04:34 |
Message-ID: | 00ab01c249ed$3bcad2e0$32021aac@chad |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
RE: [NOVICE] Simple but slowWOW! Thats a great query.
It brought down the access time from 121 secs to about 4.
Thanks a ton
Chad
----- Original Message -----
From: Henshall, Stuart - WCP
To: 'Chad Thompson' ; josh(at)agliodbs(dot)com ; pgsql-novice
Sent: Thursday, August 22, 2002 7:59 AM
Subject: RE: [NOVICE] Simple but slow
> -----Original Message-----
> From: Chad Thompson [mailto:chad(at)weblinkservices(dot)com]
>
> select l.id, l.full_phone into "8_21_2002"
> from "temp_list_tier" l LEFT JOIN
> (select phonenum
> from call_results_fixed
> where client_id = 8) as cr
> ON l.full_phone = cr.phonenum
> where cr.phonenum Is Null
>
I'm guessing you want all those in "temp_list_tier" where there is not the same phone number in call_results_fixed.
Does this (untested) run better for you:
SELECT l.id,l.full_phone INTO "8_21_2002"
FROM "temp_list_tier" AS l WHERE
WHERE NOT EXISTS
(SELECT * FROM call_results_fixed AS cr
WHERE cr.client_id=8 AND l.full_phone=cr.phonenum);
Indexes needed (I think):
cr.client_id
cr.phonenum
Maybe (I don't think so):
l.full_phone
Not sure if this is what you wanted but hope its helpfull,
- Stuart
From | Date | Subject | |
---|---|---|---|
Next Message | paul butler | 2002-08-22 15:47:53 | Re: Enforcing Case |
Previous Message | Bruno Wolff III | 2002-08-22 14:53:23 | Re: Enforcing Case |