On Mon, Jul 7, 2008 at 2:49 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> >>Problem is that there are combinations that I'll never care about > > What do u mean by the above statement. > What I meant is that I will never do a query for (e.g.) (30, <anything>). So I have an index on values that I'll potentially never care about, and that space of values could be rather large. Out of 95 values (let's say SettingId 1-95), I may only care to query about only 7 of them (let's say 1, 4, 10, 15, 16, 23, 29). At some point, I feel like there's a tradeoff. Thanks, Waynn