SQL & PL/SQL

Hi Team,

I Need some suggestions in tuning my query. Please read the below problem:

1. I have a table employees which has 2.5 Million records.

2. I have an index on this table for employee number (eno)

3. If i fire this query select * from employees where eno = 101, this executes ins 1.47 seconds.

4. I want this query to be excuted in 100 Milli seconds in first hit. I tried to use the below indexes and it got executed in 547 Milli seconds.

/*+ inxed_ffs(s, EMPLOYEE_PK)*/
/*+ ORDERED USE_NL(employees) to get first row faster */
/*+ FIRST_ROWS*/

Example Query:

SELECT /*+ inxed_ffs(s, EMPLOYEE_PK)*/ *
FROM employees s
WHERE eno = 101;

Can anyone suggest some solution to retrive this record within 100 milli seconds.

Thanks & Regards
Raghava.