Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

INTERNAL_FUNCTION in explain plan

27406582740658 Posts: 1
edited July 2020 in Social Groups

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([email protected]!).

Could any one please help me out of this issue.

Regards,

Raju

Post edited by Unknown User on

Answers

  • Prze-moCPrze-moC Posts: 1
    edited July 2020

    Run:

    EXPLAIN PLAN FOR ... (put your query here)

    Then:

    SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); 

    ... and you should see the "filter" with the INTERNAL_FUNCTION replaced by the actual conditions used.

Sign In or Register to comment.