Re: This may be a simple newbie question, but..... (about Indexes)

From: Tony! <NoSpam@Thank.You.com> > >I'm working with Informix Dynamic Server Version 7.30.UC8 on an AIX >machine. > >I have a table with about 3 fields that I want to create a Unique >index on using sql. > >If I try to insert or update a record so that the three fields match >the three fields on any other record, refuse to accept it as an entry. > >I know that I can make individual fields unique but how do I set 3 as >a group? > >I've been looking at cluster indexes, but I'm not sure if this is what >I would need to use or understand much about cluster indexes. CREATE UNIQUE INDEX foo ON bar(a, b, c);________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com