Re: Explanation of multiple-column indexes

2003-08-27 Thread Jesse Sheidlower
On Tue, Aug 26, 2003 at 09:26:55PM -0500, Matt W wrote: > Hi Jesse, > > - Original Message - > From: "Jesse Sheidlower" > > > What I'm trying to understand is how you would set up these > > indexes when you'd always be doing joins with another table. > > Suppose you have The Canonical CD D

Re: Explanation of multiple-column indexes

2003-08-27 Thread Matt W
Hi Jesse, - Original Message - From: "Jesse Sheidlower" Sent: Monday, August 25, 2003 8:26 AM Subject: Explanation of multiple-column indexes > After some discussion in a separate thread, I've been trying > to get a better understanding of the workings of multiple-

Explanation of multiple-column indexes

2003-08-25 Thread Jesse Sheidlower
After some discussion in a separate thread, I've been trying to get a better understanding of the workings of multiple-column indexes, and think I'm still missing the point. I understand indexing (last_name, first_name) in that order if you'd always be searching last names and only be searching fi