On Feb 19, 9:22 pm, Ed Prochak <edproc...@[EMAIL PROTECTED]
> wrote:
> On Feb 19, 4:32 am, falcons...@[EMAIL PROTECTED]
wrote:
>
>
>
> > I have a table with following columns:
> > division group email
>
> > Then, i create a non-unique index for:
> > division group
>
> > I insert the following data:
> > division group email
> > 1 A a...@[EMAIL PROTECTED]
> > 1 A b...@[EMAIL PROTECTED]
>
> > With this set of data in table, will the index table consist of 1
> > index record, i.e.
> > division group
> > 1 A
> > or will it contains 2 index records, i.e.
> > division group
> > 1 A
> > 1 A
>
> > 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
the DBMS is Informix. Just want to know the structure only.
|
