Fair enough!
Thanks Jonathan. todd SENIOR SOFTWARE ENGINEER todd nine| spidertracks ltd | 117a the square po box 5203 | palmerston north 4441 | new zealand P: +64 6 353 3395 | M: +64 210 255 8576 E: t...@spidertracks.co.nz W: www.spidertracks.com On Tue, 2010-10-12 at 18:47 -0500, Jonathan Ellis wrote: > On Tue, Oct 12, 2010 at 6:34 PM, Todd Nine <t...@spidertracks.com> wrote: > > Currently there is only indexing for LT and LTE expression when an EQ > > operator is present. Will it be possible to use the LT and LTE ops > > without an EQ by the 0.7.0 release? > > No. > > > If not, which of the following > > would be more efficient? > > > > 1. Creating a dummy column of 1 byte that is indexed. > > This is basically the same as doing a full range scan, only less efficient. > > > 2. Use my previous indexing scheme of 2 Super CF for longs and strings > > to get my < <= operations. Where I use the following scheme. > > I'm not sure I follow but if it's better than doing a full range scan > then it is better than 1. :) >
