From: Ananda Kumar (anandklgmail.com)
Date: Mon Jul 07 2008 - 05:20:25 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <waynnluegmail.com> wrote:
>
> On Mon, Jul 7, 2008 at 2:49 AM, Ananda Kumar <anandklgmail.com> 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
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]