Is there a way to tune such "bad" selections?
Hi,
is there a way to tune such sql that use a "quantity field > 0"?
Without changing the original sql, cause it comes from our application.
Something like this:
create index IX_DISPO01 on DISPO (ARTNR, (MENGE > 0)) tablespace prod_erp_001_idx;
to tune some like this:
SELECT DISPO.DOKART AS C1, DISPO.DOKNR AS C2, DISPO.DOKKAP AS C3, DISPO.DOKPOS AS C4, DISPO.REQUISITIONQTY AS C5, DISPO.DISPODATUM AS C6, DISPO.TACODE AS C7, DISPO.SALESBOMPOSNO AS C8, DISPO.MENGE AS C9
FROM DISPO
WHERE DISPO.ARTNR ='04939'
AND DISPO.MENGE > 0
AND DISPO.TACODE IN (2,3,4)
ORDER BY DISPO.DISPODATUM, DISPO.TACODE, DISPO.DISPOJRNNR;
is there a way to tune such sql that use a "quantity field > 0"?
Without changing the original sql, cause it comes from our application.
Something like this:
create index IX_DISPO01 on DISPO (ARTNR, (MENGE > 0)) tablespace prod_erp_001_idx;
to tune some like this:
SELECT DISPO.DOKART AS C1, DISPO.DOKNR AS C2, DISPO.DOKKAP AS C3, DISPO.DOKPOS AS C4, DISPO.REQUISITIONQTY AS C5, DISPO.DISPODATUM AS C6, DISPO.TACODE AS C7, DISPO.SALESBOMPOSNO AS C8, DISPO.MENGE AS C9
FROM DISPO
WHERE DISPO.ARTNR ='04939'
AND DISPO.MENGE > 0
AND DISPO.TACODE IN (2,3,4)
ORDER BY DISPO.DISPODATUM, DISPO.TACODE, DISPO.DISPOJRNNR;
0