[stackoverflow] [progress Openedge Abl] Idh_hist Query Is Very Slow While Searching With Date

[Aditya Amit]

Greetings!

I am trying to write a query to search thru MFG/PRO invoice table 'idh_hist' for specific date range. It is running very slow when added the date condition. But when I put off the date condition, it is very fast. Can you please suggest ways to write a query on idh_hist that runs reasonably faster with conditions.

Following is my query:

for each idh_hist no-lock where idh_domain = "d0002"
and idh_due_date = TODAY:

/* display code here... */

end.


Thanks in advance!

Continue reading...