Re: Indexing question

2010-10-06 Thread Jonas Galvez
Thanks Gavin and Joerg, that was very helpful! -- Jonas On Sun, Oct 3, 2010 at 12:44 PM, Joerg Bruehe wrote: > Hi Neil, all! > > > Tompkins Neil wrote: > > So if you have individual indexes for example field_1, field_2 and > field_3 > > etc and then perform a search like > > > > WHERE field_1 =

Indexing question

2010-10-01 Thread Jonas Galvez
Suppose I wanted to be able to perform queries against three columns of my table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be range-selecting records from the table ordering by 'created'. But I may also want to select where 'user_id' = something and 'product_id' in (list, o