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 date index
going to be what I want, or do I need a index that contains both name and
date?
BEGIN:VCARD VERSION:2.1 N:Arai;Benjamin FN:[EMAIL PROTECTED] ORG:University of California, Riverside TITLE:PhD Student TEL;WORK;VOICE:(951) 827-2838 TEL;HOME;VOICE:(951) 682-6816 TEL;CELL;VOICE:(626) 378-2992 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Department of Computer Science and Engineering=0D=0AEngineering BU2, Room = 351=0D=0AUniversity of California;Riverside;CA;92521;United States of Americ= a LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Department of Computer Science and Engineering=0D=0AEngineering BU2, Room 35= 1=0D=0AUniversity of California=0D=0ARiverside, CA 92521=0D=0AUnited States = of America URL;WORK:http://www.benjaminarai.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20060520T165426Z END:VCARD
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
