Jaime Casanova wrote: > Hi everyone, > > >From the TODO items: > Use index to restrict rows returned by multi-key index > when used with non-consecutive keys to reduce heap > accesses. > For an index on col1,col2,col3, and a WHERE clause of > col1 = 5 and col3 = 9, spin though the index checking > for col1 and col3 matches, rather than just col1; also > called skip-scanning. > > > I was looking in the archives something about this but > i found nothing. Where can i found the thread (i > suppose should be one) about this issue?
I don't remember any detailed discussion on it except that it would be a good idea. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
