Why is sort segment growing extremely big on simple query?

Hello,

We're written a query to read large clobs from an Oracle clob field. Below is the query that we are using which has worked so far for all our clients. But this one client is having issues with the sort segment growing extremely large when making a number of calls repeatedly. Is there a better way in Oracle to retrieve large amounts of content from clob fields.

SELECT SUBSTR (si_large_content, 1, 4290) AS txt

   FROM search_index
  WHERE si_id = 1002020

We're using Oracle 9i running on a Linux system. The query is being executed through CFMX if that makes any difference.

Thanks

-- 


* Don Vaillancourt

Director of Software Development


*

*WEB IMPACT INC.*

phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: donv_at_web-impact.com <mailto:donv_at_webimpact.com>
web: http://www.web-impact.com



/ This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright. If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
/