performance improvement of clob data [message #558743] |
Tue, 26 June 2012 06:08 |
|
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
|
|
|
|