[GENERAL] Multiple column indexes

[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 the potential performance gains?

Thanx,
Garth
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match