Originally posted by nir_s
3.To enforce the optimizer choosing FTS instead of index access you should insert the the "FULL" hint in the "select" statement,like in the following example:

select /*+ FULL */
f_name,l_name,address
from emp
where emp_no=1;

Regards,
Nir
No, he has specifically mentioned WHERE clause. Pando explained it.