You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Simple query of "Inventory Register" is taking too much time with following tables

Received Response
22
Views
1
Comments
edited Mar 21, 2024 12:36PM in Inventory Management 1 comment

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!