1 Reply Latest reply on Jul 10, 2020 9:16 AM by Prze-moC

    INTERNAL_FUNCTION in explain plan

    2740658

      Hi All,

      I am working on performance tuning the query, when I ran the explain plan it is getting INTERNAL_FUNCTION for date column,

      Below is the query I am working on,

       

      SELECT /*+ PARALLEL(CII) PARALLEL(XMRE) */

          CII.INSTANCE_NUMBER,

            CII.ATTRIBUTE3,

            CII.ATTRIBUTE6,--Asset Instance Data Source

            CII.INSTANCE_ID AS MAINTENANCE_OBJECT_ID,

            CII.INVENTORY_ITEM_ID,

            CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

            CII.CREATION_DATE,

            CII.CREATED_BY,

            CII.LAST_UPDATED_BY

          FROM CSI_ITEM_INSTANCES CII,

            XXEAM_MAINTENANCE_REGIME_ERROR XMRE

          WHERE CII.INSTANCE_NUMBER       =XMRE.ASSET_NUMBER(+)

          AND (((TRUNC(CII.CREATION_DATE) =TRUNC(to_date(SYSDATE)))

          OR (TRUNC(XMRE.CREATION_DATE)   <TRUNC(SYSDATE)))

          OR TRUNC(CII.CREATION_DATE) BETWEEN :P_FROM_DATE AND :P_TO_DATE)

          and CII.INVENTORY_ITEM_ID=NVL(:P_INV_ITEM_ID,CII.INVENTORY_ITEM_ID);

       

       

      Now, In the explain plan it is showing like,

       

      TRUNC(INTERNAL_FUNCTION(CREATION_DATE))=TRUNC(SYSDATE@!).

       

      Could any one please help me out of this issue.

       

      Regards,

      Raju