Re: Why is sort segment growing extremely big on simple query?

Don Vaillancourt wrote:

> Thank you.
>
> Will the package function that you specify, dbms_lob.substr, populate
> the temporary tablespace just like the substr, or is it a bit more
> optimized.

Hopefully optimized but there is a far more important consideration.

You won't be using SUBSTR on anything larger than 32K.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)