Joining on text field VS int
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-performance@xxxxxxxxxxxxxx
Subject
: Joining on text field VS int
From
: Radhika S <
rs88820@xxxxxxxxx
>
Date
: Wed, 6 Jan 2010 23:21:47 -0500
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 .
Follow-Ups
:
Array comparison
From:
ramasubramanian
Re: Joining on text field VS int
From:
Nikolas Everett
Prev by Date:
Re: noob inheritance question
Next by Date:
Re: Digesting explain analyze
Previous by thread:
noob inheritance question
Next by thread:
Re: Joining on text field VS int
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
