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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh Sent: Tuesday, March 15, 2005 12:48 PM 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 &=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 -- //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. -- //www.freelists.org/webpage/oracle-l