Re: Unique or non-unique indices

In article <33DE6946.5424@bellsouth.net>, MIS Dept <whsmis1@bellsouth.net> writes >Here's an indexing question: > >I am in the process of adding a few indices to a given table; the table >itself consists of over 3 million rows. I've had a tendency to just >'create index' without thought to the uniqueness of the index. If these >indices are unique, is there any benefit to defining them as such? > Informix then enforces uniqueness. This means a bug in the application cannot cause duplicates in that column. >It appears that the optimizer doesn't really care if the index is unique >or not. I did some testing and in some instances my cost actually >increased, slightly. > >Did I miss something here? > > >TIA > >John Carlson >WH Smith, Inc. -- David Williams