SQL Performance (MOSC)

MOSC Banner

PARALLEL Hint ignored when there is a function used as a column in a SELECT statement

edited Aug 19, 2018 5:01AM in SQL Performance (MOSC) 2 commentsAnswered

Hello,

I am playing around with the /*+ PARALLEL (AUTO) */ Hint in a select statement and it looks like this hint is ignored if there is a function used as a column in a select column.

example pseudo code:

 

select /*+ Parallel (auto)  */

e.employee_code,

  function.display_fullname fullname

from employees e;

versus:

select

e.employee_code,

  func.display_fullname fullname

from employees e;

Both these return same cost in explain plan.  however if you remove the function, it uses the hint and it is like noght and day.

select

e.employee_code

from employees e;

Why is this?  Can someone point me in the write direction to white papers or solutions?  I have functions that need to be used and can not be made into actual select statements as they are much too complex.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center