RE: query tune

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 15 Mar 2005 20:56:58 +0100
Message-Id: <20050315195719.C448F80111C1@smtp-out3.tiscali.nl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh
Sent: Tuesday, March 15, 2005 20:48
To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 15 2005 - 15:00:47 CST