Re: [SQL] join optimization problem

2003-08-03 Thread Toby Tremayne
y address as well as the list. - -- - ---- Life is poetry - write it in your own words - Toby Tremayne Code Poet and Zen Master of the Heavy Sleep Senior Technical Consultant Lyricist Software www.lyri

Re: [SQL] join optimization problem

2003-08-03 Thread Toby Tremayne
294.28 rows=8563 loops=1537) Total runtime: 545763.83 msec (10 rows) any input at all would be great. cheers, Toby On Friday 01 August 2003 10:36, Tom Lane wrote: > Toby Tremayne <[EMAIL PROTECTED]> writes: > > the explain data I'm currently getting is this: > > "exp

[SQL] join optimization problem

2003-07-31 Thread Toby Tremayne
heers, Toby - -- - ---- Life is poetry - write it in your own words - Toby Tremayne Code Poet and Zen Master of the Heavy Sleep Senior Technical Consultant Lyricist Software www.lyricist.com.au +61 416 048 090 ICQ: 1310791