Re: [SQL] sub-query optimization

2003-02-14 Thread Brad Hilton
On Fri, 2003-02-14 at 04:59, Tomasz Myrta wrote: > Brad Hilton wrote: > > > select * from articles where exists > > (select 1 from article_categories, categories, category_map > >where > >article_categories.article_id = articles.id and > >c

Re: [SQL] sub-query optimization

2003-02-14 Thread Brad Hilton
On Fri, 2003-02-14 at 14:08, Tom Lane wrote: > Brad Hilton <[EMAIL PROTECTED]> writes: > > ... If I modify the query slightly: > > > > > select 1 from article_categories > > --> > > select 1 from articles, article_categories > >