SQL Performance (MOSC)

MOSC Banner

Concatenated Column not using Index

edited Mar 25, 2015 10:00AM in SQL Performance (MOSC) 2 commentsAnswered

SQL Text   : select Department_id , Manager_id 

                from employees where First_name || ' - ' || last_name

                in ('Neena - Kochhar')

-------------------------------------------------------------------------------

| Id  | Operation                            | Name      | Rows  | Bytes | Cost (%CPU)| Time     |

-------------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |                      |     1 |    22 |     3   (0)| 00:00:01 |

|*  1 |  TABLE ACCESS FULL| EMPLOYEES |     1 |    22 |     3   (0)| 00:00:01 |

-------------------------------------------------------------------------------

How can I make the above query use index, maybe I should try hints...

Tagged:

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