Well, then it's decided to try with two indexes...
Thx... :)
BTJ
Bruno Wolff III wrote:
On Wed, Dec 01, 2004 at 23:16:48 -0800, Vincent Hikida <[EMAIL PROTECTED]> wrote:
I believe that it is better to have a concatenated key of (toDate,FromDate). The reason the toDate should come first is that for more "recent" records, finding curDates less than toDate is much more selective than finding curDates greater than fromDate. Actually I'm not sure if fromDate is that helpful either as part of the concatenated key (it probably depends) but definitely not by itself.
I combined index won't be very useful for the kind of search he is doing. And not having an index on FromDate could hurt in some cases depending on the distribution of values.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
