Hi firends,

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...