oops.... yeah... must have read it clearly rgds, dotyet
On 2/22/08, Erik Jones <[EMAIL PROTECTED]> wrote: > > > On Feb 22, 2008, at 8:38 AM, Dot Yet wrote: > > > that would mean > > > > Every row in foo for column f1 has to be unique > > and > > Every row in foo for column f2 has to be unique > > The OP was asking about maintaining normal indexes on each in > addition to the unique index on (f1, f2), not separate unique indexes. > > Erik Jones > > DBA | Emma(R) > [EMAIL PROTECTED] > 800.595.4401 or 615.292.5888 > 615.292.0777 (fax) > > Emma helps organizations everywhere communicate & market in style. > Visit us online at http://www.myemma.com > > > >