On 03/29/2011 01:53 PM, Rich Shepard wrote:
> On Tue, 29 Mar 2011, wes wrote:
>
>> However, I must ask, out of curiosity: why would you want to index a column
>> whose contents are irrelevant?
> Wes,
>
> Furthermore, I'm a believer in each table having a primary key, especially
> when that table is used in multi-table joins.
>
> Rich
>
Yes, a primary key is good, but how will this table be joined to
others? Will you do something like this?
SELECT foo
FROM bar
JOIN baz ON bar.rowid = baz.barkey;
Indexes on joined columns also serve this purpose.