Re: [GENERAL] Multiple column indexes

2007-01-19 Thread Garth Keesler
I thought as much. Thanx for the reply, Garth Merlin Moncure wrote: On 1/19/07, Garth Keesler <[EMAIL PROTECTED]> wrote: I have a primary key made up of two varchar(128) columns, typically less than 16 chars each. Concatenating the two columns would still be unique. Would it make sense to conc

Re: [GENERAL] Multiple column indexes

2007-01-19 Thread Merlin Moncure
On 1/19/07, Garth Keesler <[EMAIL PROTECTED]> wrote: I have a primary key made up of two varchar(128) columns, typically less than 16 chars each. Concatenating the two columns would still be unique. Would it make sense to concat the two columns, using a unique separator like '~' and index on that

[GENERAL] Multiple column indexes

2007-01-19 Thread Garth Keesler
I have a primary key made up of two varchar(128) columns, typically less than 16 chars each. Concatenating the two columns would still be unique. Would it make sense to concat the two columns, using a unique separator like '~' and index on that single column or would that be more trouble than t