[firebird-support] creating 2 indexes of the same records

[Ismael L. Donis Garcia]

Can some problem exist when creating 2 indexes of the same records?

CREATE UNIQUE INDEX FK_SCEMMES_A ON SCEMMES (IDAC,IDREG,NUMC);
CREATE UNIQUE DESCENDING INDEX FK_SCEMMES_D ON SCEMMES (IDAC,IDREG,NUMC);

I make it because I need values max

select max(m.numc) as numc from scemmes m where ((m.idac=1) and (m.idreg=1))


Best Regards
=========
|| ISMAEL ||
=========

[Non-text portions of this message have been removed]