On Feb 19, 4:32=A0am, falcons...@[EMAIL PROTECTED]
wrote:
> I have a table with following columns:
> division =A0 group =A0 email
>
> Then, i create a non-unique index for:
> division =A0 group
>
> I insert the following data:
> division =A0 group =A0 email
> 1 =A0 =A0 =A0 =A0 =A0 =A0A =A0 =A0 =A0 =A0 a...@[EMAIL PROTECTED]
> 1 =A0 =A0 =A0 =A0 =A0 =A0A =A0 =A0 =A0 =A0 b...@[EMAIL PROTECTED]
>
> With this set of data in table, will the index table consist of 1
> index record, i.e.
> division =A0 group
> 1 =A0 =A0 =A0 =A0 =A0 =A0A
> or will it contains 2 index records, i.e.
> division =A0 group
> 1 =A0 =A0 =A0 =A0 =A0 =A0A
> 1 =A0 =A0 =A0 =A0 =A0 =A0A
>
> Thanks for prompt reply.
You give No mention of what DBMS you are using so it is impossible to
answer directly.
But I do have to ask: Why do you care? What business need will this
knowledge serve?
Ed
|
