Simple query of "Inventory Register" is taking too much time with following tables
Summary:
Hi All,
As i am trying to get data for Inventory Register Report by using this simple Query
its not completed yet but taking too much time (8-9) minutes because of the many recrods almost more than 1.5 lakh with parameters of one month for single organization unit
This is the query and i need to optimied it or finetune
please let me know if there is any possibility
Content (please ensure you mask any confidential information):
SELECT IMT.TRANSACTION_ID,
ccdl.distribution_id,
IOP.ORGANIZATION_CODE,
ESB.ITEM_NUMBER,
ESB.DESCRIPTION,
ITT.TRANSACTION_TYPE_NAME,
TRX_SOURCE.TRANSACTION_SOURCE_TYPE_NAME,
0