query tune
- From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Mar 2005 14:48:12 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
