oops.... yeah... must have read it clearly
rgds,
dotyet
On 2/22/08, Erik Jones <erik@xxxxxxxxxx> 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®
erik@xxxxxxxxxx
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
