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

Could any one please help me out of this issue.

Regards,

Raju

Prze-moC

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.