Home » RDBMS Server » Performance Tuning » INTERNAL_FUNCTION appears at explain plan (11g, 11.2.0.3, solaris10)
INTERNAL_FUNCTION appears at explain plan [message #627608] Thu, 13 November 2014 01:24 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

Below is the production database explain plan -

Toggle Spoiler


Again, I have generated explain plan for the query in my local database and it's not appearing.

Toggle Spoiler

Though data type of both the columns are varchar2 but data available in number.

Below are the table structure -
Toggle Spoiler

Please let me know why there is different behaviour in explain plan?

Need your valuable inputs..

Regards,
Ashish


Edited by Lalit, added spoiler tags

[Updated on: Fri, 14 November 2014 06:37] by Moderator

Report message to a moderator

Re: INTERNAL_FUNCTION appears at explain plan [message #627633 is a reply to message #627608] Thu, 13 November 2014 09:24 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Please post the data types of the columns involved in the internal conversion.
Re: INTERNAL_FUNCTION appears at explain plan [message #627634 is a reply to message #627633] Thu, 13 November 2014 09:32 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
It's a too lengthy post, I would prefer using spoiler tags.

Anyway, my thought is that there must be a data type difference between the columns involved in the filter predicate, due to which Oracle had to apply internal conversion.
Re: INTERNAL_FUNCTION appears at explain plan [message #627635 is a reply to message #627633] Thu, 13 November 2014 09:44 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
There's DESCs of the table above you know.

T_CUSTOMER_CD NOT NULL VARCHAR2(20)
TXT_INSURED_ID VARCHAR2(100)
Re: INTERNAL_FUNCTION appears at explain plan [message #629066 is a reply to message #627635] Wed, 03 December 2014 00:02 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

Data type of both the columns are Varchar2 data type and numbers are getting stored into it. Because of that oracle using INTERNAL_FUNCTION.

Regards,
Ashish
Previous Topic: AWR report
Next Topic: Effective way to update a column to null (based on a condition) quickly in a huge 800 GB table
Goto Forum:
  


Current Time: Thu Mar 28 06:56:40 CDT 2024