Home » RDBMS Server » Performance Tuning » performance improvement of clob data (oracle 10.2.0.5 solaris 64 bit)
performance improvement of clob data [message #558743] Tue, 26 June 2012 06:08 Go to next message
guddu_12
Messages: 175
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
Re: performance improvement of clob data [message #558758 is a reply to message #558743] Tue, 26 June 2012 07:04 Go to previous message
Michel Cadot
Messages: 59815
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I there any way to retrive data with clob and it should be fast as well.


No.

Regards
Michel
Previous Topic: SGA related queries
Next Topic: Outer join causes much slower performance
Goto Forum:
  


Current Time: Fri Nov 28 01:37:48 CST 2014

Total time taken to generate the page: 0.12658 seconds