On 16 June 2010 19:07, Bryan Montgomery <monty@xxxxxxxxxxx> wrote: > If I do select * from Table_A a, Table_X x where a.id = x.id > and it only returns 1 or a few rows, should it use an index if I have an > index built on Table_A using id? It should because it scans Table_A too. > Or do I need an index individually on B & C? Yes. Indexes are not inherited. -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray.ru@xxxxxxxxx / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
