DROP INDEX CMP00356_FK
/
CREATE INDEX CMP00356_FK ON ITMAPURPREC (NRCOMPRA ASC, CDCENTITMAP ASC, NRSEQITMAP ASC, CDFILIAP ASC, NRORG)
/
DROP INDEX ITMAPURPREC_01
/
CREATE INDEX ITMAPURPREC_01 ON ITMAPURPREC (CDCENTITMAP, NRSEQITMAP, CDFILIAP, CDPRODITMAP, IDITMSELAPUR, CDFORNITMAP, NRORG)
/
CREATE INDEX FORNECEDOR_SUP01 ON FORNECEDOR (CDFORNECED, NRORG, IDUTQTDISPFORN, CDTIPCOB, IDGERAFDTENT, NRITEMAF, VRPERPIFORN, IDSITUCADA, IDTIPOFORN, CDQUALIF, IDFORNAUTO, DTVALQUALIF, NRINSJURFORN, NMRAZSOCFORN, NMFANTFORN, IDTPFRETFORN, DTCADAFORN, VRMINAUTFOR, QTMINAUTFOT, IDGERCONTPGT)
/
CREATE INDEX FILIAL_SUP01 ON FILIAL (CDFILIAL, NRORG, IDFUNCAOFILI, NMFILIAL, NMRAZSOCFILI, IDCNTRRESC, CDREGIAO, CDFILCENTCMP, CDFILCENTPME, IDFILCENTPME, CDFORNOPELOG, IDCONSORCFIL, IDCONSAFORCFIL, CDEMPRESA, IDTPIJURFILI, NRINSJURFILI, CDINSCMUNI, CDINSCESTA)
/
CREATE INDEX PRODUTO_SUP01 ON PRODUTO (CDPRODUTO, NRORG, NMPRODUTO, CDARVPROD, VRPEFATOCORR, VRFATOCONV, CDNVPRODUTO, SGUNIDADE, CDPRODNIVANTE, CDPRODESTO, VRARREDREQ, VRARREDCMP, VRPEFATOCOCC, DSCOMPLNOME, VRFATACRCMP, VRFATPERDCMP, VRPELIARRCMP, VRPELSARRCMP, IDPRODPROD, CDPRODPROD, VRFATOCONVPR, IDPRCMPATIVO)
/
DROP INDEX CMP00034_FK
/
CREATE INDEX CMP00034_FK ON MARCPROD (CDMARCA, CDPRODUTO, VRARREDEMPMAR, VRRENDATUMAR, NRORG)
/
DROP INDEX CMP00259_FK
/
CREATE INDEX CMP00259_FK ON PARAMPRODSUP (CDFILIAL, CDFILIOPELOG, NRORG)
/
DROP INDEX CMP00266_FK
/
CREATE INDEX CMP00266_FK ON PARAMPRODSUP (CDFILIOPELOG, CDFILIAL, NRORG)
/
CREATE INDEX IMPOSTO_SUP01 ON IMPOSTO (CDIMPOSTO, NRORG, IDACRPRODENTRNF)