Re: [HACKERS] BTree index and optimizer

2003-12-04 Thread Hannu Krosing
Anand, VJ (MED, GEMS-IT) kirjutas K, 03.12.2003 kell 18:18: > Hello: > > I am trying to find out, how is the B-tree index implemented for > multiple columns? does Postgres, just > concatenate the columns --- Yes. > if this is the case, then how is the > search performed? Also,

[HACKERS] BTree index and optimizer

2003-12-03 Thread Anand, VJ (MED, GEMS-IT)
Hello: I am trying to find out, how is the B-tree index implemented for multiple columns? does Postgres, just concatenate the columns --- if this is the case, then how is the search performed? Also, does the optimizer choose the index, only when the constraining is