You can write " SELECT ID, FIRST_NAME, LAST_NAME FROM ADDRESS WHERE ADDRESS.LAST_NAME STARTING ?". That way the optimizer will know it can use index.

--
Mgr. Jiri Cincura
Independent IT Specialist