Re: query tune

Upgrade your Oracle license to SB, the Silver Bullet option. Obviously, it is the inverse of the BS option.

At 12:48 PM 3/15/2005, Seema Singh wrote:
>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

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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