how many rows would be there in this table and what is the growth rate of this table.
regards anandkl On 7/7/08, Waynn Lue <[EMAIL PROTECTED]> wrote: > > 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 >