Re: [GENERAL] Question about clustering multiple columns

2006-06-16 Thread Bruno Wolff III
On Tue, Jun 13, 2006 at 09:04:15 -0700, Benjamin Arai <[EMAIL PROTECTED]> wrote: > Hi, > > I have a database where there are three columns (name,date,data). The > queries are almost always something like SELECT date,data FROM table WHERE > name=blah AND date > 1/1/2005 AND date < 1/1/2006;. I

[GENERAL] Question about clustering multiple columns

2006-06-15 Thread Benjamin Arai
Hi,   I have a database where there are three columns (name,date,data).  The queries are almost always something like SELECT date,data FROM table WHERE name=blah AND date > 1/1/2005 AND date < 1/1/2006;.  I currently have three B-tree indexes, one for each of the columns.  Is clustering on d