Re: Joining on text field VS int
От
Nikolas Everett
Тема
Re: Joining on text field VS int
Дата
Msg-id
d4e11e981001071052l1a5b03e9mfd12b2579aa50815@mail.gmail.com
Ответ на
Joining on text field VS int (Radhika S)
Список
Дерево обсуждения
Joining on text field VS int Radhika S <rs88820@gmail.com>
Re: Joining on text field VS int Nikolas Everett <nik9000@gmail.com>
Joining via a tinyint or something will make your large table smaller which is nice. Smaller tables = faster tables.
On Wed, Jan 6, 2010 at 11:21 PM, Radhika S <rs88820@gmail.com> wrote:
Hi,
I am going to test this out but would be good to know anyways. A large
table is joined to a tiny table (8 rows) on a text field. Should I be
joining on an int field eg: recid intead of name? Is the performance
affected in either case?
Thanks .
В списке pgsql-performance по дате отправления
