I created an Oracle Form screen block for the EMP table. It contains
field columns EMP.EMPNAME, AND EMP.EMPNO.
The table has 2 indexes each on these columns.
1. Then i enter a query and put "SCOTT" on the empname field. And
it retrieve the record fast.
2. Then i enter a query and put "SCO%" on the firstname field. and again the query returns fast.
My question is... is query #2 use the 'LIKE' contidion clause?
Because I tried to search the EMP table using this command:
sql> select * from emp where empname like 'SCO%' ;
....and the query took very long to retrieve the record.
How can i make this sql*plus query use the index?
Thank you all in advance...