performance improvement of clob data [message #558743] |
Tue, 26 June 2012 06:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e1807e23242de2805a657f4ad9ae6654?s=64&d=mm&r=g) |
guddu_12
Messages: 227 Registered: April 2012 Location: UK
|
Senior Member |
|
|
Dear All,
I have a view on which there is a clob column, when ever i query on view and select the clob it takes time to retun data and without clob it is much faster.
I there any way to retrive data with clob and it should be fast as well.
CREATE OR REPLACE FORCE VIEW "OVSD"."GSP_INCSUM" ("INC_SER_ID", "INC_NAME")
AS
SELECT ser_id AS INC_SER_ID,
sd_ser_4k5.se5_4k5 AS INC_name
FROM sd_servicecalls
LEFT OUTER JOIN sd_ser_4k5
ON se5_ser_oid = ser_oid;
inc_name is clob column.
where ever i query on this view and select inc_name the query takes time but when it is deselected it doesn't.
Please help me know how can i achive performance for clob data
|
|
|
|