Simple Index Hints question

Hi All,

I am just a beginner and are experimenting with index hints.

I would like to know if I can force an index hints or a index_ffs hints in a query that comprises of multiple subqueries which are 3 level deep.

If not what are the most common solution or a set of metrics to help identify and tune the problem in a production environment.

ie. The table time_sheets are a relatively huge table opposed to the rest, I would just like to verify if I can force an index_ffs on time_sheets.

Any pointers will be very much appreciated.

SELECT * FROM employees
WHERE emp_seq IN
(SELECT /*+INDEX_FFS(time_sheets emp_seq) */emp_seq

    FROM time_sheets t
WHERE proj_seq =
(SELECT proj_seq

         FROM projects
WHERE name = 'Debugger')

      --if no results, try Migration instead AND rpt_date =
(SELECT MAX(effective_date) FROM sal_history s
WHERE s.emp_seq = t.emp_seq))

Please let me know if you need more explicit information interms of my experimentation.

Thanks All in advance and you have a pleasant day.

Kenny- Received on Sun Apr 02 2000 - 05:54:11 CDT