Re: Index Usage using IN
От
Jeffrey W. Baker
Тема
Re: Index Usage using IN
Дата
Msg-id
1138825370.8376.5.camel@toonses.gghcwest.com
Ответ на
Index Usage using IN (Ralph Mason)
Список
Дерево обсуждения
Index Usage using IN Ralph Mason <ralph.mason@telogis.com>
Re: Index Usage using IN "Jeffrey W. Baker" <jwbaker@acm.org>
Re: Index Usage using IN "Jeffrey W. Baker" <jwbaker@acm.org>
Re: Index Usage using IN Tom Lane <tgl@sss.pgh.pa.us>
Re: Index Usage using IN Bruno Wolff III <bruno@wolff.to>
Re: Index Usage using IN Hari Warrier <hbhaskaran@gmail.com>
On Thu, 2006-02-02 at 09:12 +1300, Ralph Mason wrote: > Hi, > > I have 2 tables both have an index on ID (both ID columns are an oid). > > I want to find only only rows in one and not the other. > > Select ID from TableA where ID not IN ( Select ID from Table B) Have you considered this: SELECT ID from TableA EXCEPT Select ID from Table B ? -jwb
В списке pgsql-performance по дате отправления
