Oracle Text Query Optimization

Platform: oracle 9iR2 / Solaris 9

This probably a very simple answer. We have a table with text indexed documents.

The following query will retrieve circa 16,000 rows.

SELECT score(1) score,

        wcc.candidate_id
FROM wd_cand_cvs wcc
WHERE contains(cv_text,'sales, sap, hrms, oracle, peoplesoft',1) > 0 ORDER BY 1 DESC; We only want the first 15 (by first I mean the first when ordered by the score).

Without the ORDER BY the first results arrive in less than a second. With the order by, the results take circa 40 seconds (obviously as it has to sort the data before displaying the irst result set).

Is there a quick and easy way to speed this up?

-- 

jeremy