query tune

Hi,

What changes required in below query to make faster?

select url_stub,

       page_title,

       one_line_item_desc,

       score(10) content_score

from url_pages sp

where contains( sp.page_body, '(non-fee campgrounds)*2 | (non-fee & campgrounds)', 10) > 0

and template_key = 'gorp_basic_template'

and live_p = 't'

and obsolete_p = 'f'

order by content_score desc

thanks
-seema

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 15 2005 - 14:51:39 CST