RE: query tune
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Mar 2005 20:56:58 +0100
what about (bitmap) indexes on template_key, live_p, and obsolete_p to start
with?
what is your (slow) execution plan in the first place?
kind regards,
Lex.
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Seema Singh
Sent: Tuesday, March 15, 2005 20:48
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
