On 1/12/06 10:37 AM, "Greg Stark" <[EMAIL PROTECTED]> wrote:
> If it's only a factor of 3-4 then the merge join should be faster. If it's
> really two orders of magnitude (100x?) then the nested loop below would be
> faster. I think in 8.1 (and I think in 8.0 too) the planner is capable of
> comin
Wes <[EMAIL PROTECTED]> writes:
> This appears to be very inefficient. B is almost two orders of magnitude
> larger than A. C is about 3-4 times as big as B (record count). My
> statement (with the same single 'B' table as above) produces:
If it's only a factor of 3-4 then the merge join shou
On 1/12/06 12:23 AM, "Jonel Rienton" <[EMAIL PROTECTED]> wrote:
> Resending sample query, darn where clause didn't wrap
>
> select a.*,b.* from a
> left outer join b on a.id = b.a_id
> where b.id is null;
I tried something along those lines a while back, and it was orders of
magnitude slower. T
neral
Subject: [GENERAL] Finding orphan records
I'm trying to find/delete all records in table A that are no longer
referenced by tables B or C. There are about 4 million records in table A,
and several hundred million in tables B and C.
Is there something more efficient than:
select address_ke
NERAL] Finding orphan records
I'm trying to find/delete all records in table A that are no longer
referenced by tables B or C. There are about 4 million records in table A,
and several hundred million in tables B and C.
Is there something more efficient than:
select address_key, address from
I'm trying to find/delete all records in table A that are no longer
referenced by tables B or C. There are about 4 million records in table A,
and several hundred million in tables B and C.
Is there something more efficient than:
select address_key, address from addresses where ( not exists(sele
