are there any experiences about the performance of indices with different data types.
How do the performance of an index that consists of
- an integer field - a varchar() field - a text field
differ?
Is it a waste of memory/performance to make a text field primary key?
Thanks,
Hans
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
