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
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

Search This Blog

Blogs List

  • ►  2024 (1)
    • ►  April (1)
  • ►  2023 (14)
    • ►  October (3)
    • ►  July (2)
    • ►  May (2)
    • ►  April (2)
    • ►  March (5)
  • ►  2022 (2)
    • ►  November (1)
    • ►  January (1)
  • ►  2021 (1)
    • ►  February (1)
  • ►  2020 (3)
    • ►  September (1)
    • ►  May (1)
    • ►  February (1)
  • ►  2019 (6)
    • ►  November (3)
    • ►  September (2)
    • ►  February (1)
  • ▼  2018 (40)
    • ►  December (3)
    • ▼  September (7)
      • API To Load Lookup Values
      • API To Load Flex Values
      • Logic to run fast Query on Date parameters
      • Procedure Based Report
      • Create Index To Run Fast Query
      • Report To Generate Output in Concurrent Program Ou...
      • GL Interface Error Lookup Type
    • ►  August (5)
    • ►  July (25)
  • ►  2016 (3)
    • ►  February (3)

About Me

My photo
Shivaji Umale
Pune, Maharashtra, India
View my complete profile

Report Abuse

Thanks to visit.. Picture Window theme. Powered by Blogger.