Query Execution Plan

   Hello,

I am facing one problem relating oracle index.

I am running below query.

SELECT NameEntityType2.NameKey FROM Name NameEntityType2, NameTelecom WHERE NameEntityType2.NameKey = NameTelecom.NameKey (+)and( UPPER (NameEntityType2.NameCode) LIKE 'MECC%') 

On table name namekey is primary key and on table nametelecom namekey is primary and function based index is present on namecode column.

Now the problem is that when i am checking the execution plan of above query it show name is access full(oracle is not using index for accessing name table) but i want oracle should use this index to retrive data from name table.