RE: Indexing a CLOB

From: Ben Wittmeier <Ben.Wittmeier_at_gov.ab.ca>
Date: Thu, 12 Feb 2009 11:08:55 -0700
Message-ID: <2BC7419BF42B0146A7BB8C52A236313D02F1D694_at_E03-GOA-EXCH-66.goa.ds.gov.ab.ca>



I was passing this question on from someone else, so I'm not sure where the performance problem is or what the developer is doing with the clob. I'll pass back all comments and questions and see where it goes.  

Thanks for the response.


From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Thursday, February 12, 2009 10:38 AM To: Ben Wittmeier
Cc: oracle-l_at_freelists.org
Subject: Re: Indexing a CLOB

what's he doing to this that is slow? insert/update/select ?

On Thu, Feb 12, 2009 at 4:40 PM, Ben Wittmeier <Ben.Wittmeier_at_gov.ab.ca> wrote:

         We need to increase the size of a data field beyond its varchar2(4000)

        definition because 4000 characters isn't large enough. The field is

        currently not indexed. The developer has done some initial testing with

        CLOB's but found the performance with the CLOB seemed slow so he's

        wondering about an index on the field. Though he also said the slow

        performance may be a result of the way he's doing things with the CLOB

        (as this is new to him). Are there any options available to index the

        CLOB field to improve performance? Oracle mentions using a CONTEXT
        index....         

        Does anyone have any thoughts on indexing CLOB fields?         

        This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.         

	--
	http://www.freelists.org/webpage/oracle-l
	
	
	




-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 12 2009 - 12:08:55 CST

Original text of this message