OracleApps02
Shivaji Rajaram Umale
Mob No. +91-7875947412
Logic to run fast Query on Date parameters
select
/*+ parallel(aa, 4) parallel(xx, 4) */
*
from
XXDM_MEDNEXT_CLAIM_INV_V MDX
,
(select
:
P_FROM_DATE fromdate
,:
P_TO_DATE todate
from
dual
)
xx
where
MDX
.
INVOICE_DATE
>=
xx
.
fromdate
and
MDX
.
INVOICE_DATE
<=
xx
.
todate
Newer Post
Older Post
Home