Jim C. Nasby wrote on 25/04/2005 01:28:
On Sat, Apr 23, 2005 at 10:39:14PM +, Patrick TJ McPhee wrote:
In article <[EMAIL PROTECTED]>,
Rob Kirkbride <[EMAIL PROTECTED]> wrote:
% I've done a explain analyze and as I expected the database has to check
% every row in each of the three tables b
On Sat, Apr 23, 2005 at 10:39:14PM +, Patrick TJ McPhee wrote:
> In article <[EMAIL PROTECTED]>,
> Rob Kirkbride <[EMAIL PROTECTED]> wrote:
>
> % I've done a explain analyze and as I expected the database has to check
> % every row in each of the three tables below but I'm wondering if I can
In article <[EMAIL PROTECTED]>,
Rob Kirkbride <[EMAIL PROTECTED]> wrote:
% I've done a explain analyze and as I expected the database has to check
% every row in each of the three tables below but I'm wondering if I can
This is because you're returning a row for every row in the three
tables.
On 4/22/05, Rob Kirkbride <[EMAIL PROTECTED]> wrote:
> I've got a query that takes quite some time to complete. I'm not an SQL
> expert so I'm not sure how to improve things.
> I've done a explain analyze and as I expected the database has to check
> every row in each of the three tables below but
