RE: query tune

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Tue, 15 Mar 2005 12:56:23 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B43942A@fiji.arraybp.com>

What is "faster"? How slow is it? How fast do you want it? What is = the explain plan? What if any, waits are occurring? How recent are = statistics? Do you have histograms? etc.

---

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----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 12:48 PM
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 &=20 campgrounds)', 10) > 0

and template_key =3D 'gorp_basic_template'

and live_p =3D 't'

and obsolete_p =3D 'f'

order by content_score desc

thanks
-seema

--

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

This electronic message transmission is a PRIVATE communication which = contains
information which may be confidential or privileged. The information is = intended=20
to be for the use of the individual or entity named above. If you are = not the=20
intended recipient, please be aware that any disclosure, copying, = distribution=20
or use of the contents of this information is prohibited. Please notify = the
sender of the delivery error by replying to this message, or notify us = by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 15 2005 - 14:58:55 CST