Re: [SQL] Why would this slow the query down so much?

2001-10-16 Thread Stuart Grimshaw
On Monday 15 October 2001 16:12 pm, Tom Lane wrote: > Stuart Grimshaw <[EMAIL PROTECTED]> writes: > > SELECT a.category, b.headline, b.added, c.friendlyname > > FROM caturljoin as a > > INNER JOIN stories as b ON (a.url = b.source) > > INNER JO

[SQL] Why would this slow the query down so much?

2001-10-15 Thread Stuart Grimshaw
I have 3 tables that I am trying to join together: -- Table "caturljoin" Attribute | Type | ---+-+ category | integer | url | integer | Index: caturljoin_url caturljoin_cat Table "stories" Attribute |