Re: [GENERAL] Performance with different index types

2003-08-18 Thread scott.marlowe
On Mon, 18 Aug 2003, Johann Uhrmann wrote: > Hello, > > 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? It's not so much ab

[GENERAL] Performance with different index types

2003-08-18 Thread Johann Uhrmann
Hello, 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