Subject creating 2 indexes of the same records
Author 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]