On 20.02.2008 03:05, falconsoon@[EMAIL PROTECTED]
wrote:
> 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.
There's plenty do***entation online:
http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp
http://www-306.ibm.com/software/data/informix/pubs/
robert
|
