Re: query tune
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Tue, 15 Mar 2005 14:14:58 -0700
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
>
>
>--
>//www.freelists.org/webpage/oracle-l
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
