Subject | creating 2 indexes of the same records |
---|---|
Author | Ismael L. Donis Garcia |
Post date | 2012-02-24T14:00:46Z |
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]
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]