Re: Indexing a CLOB
- From: z b <zimsbait@xxxxxxxxx>
- To: Ben.Wittmeier@xxxxxxxxx
- Date: Thu, 12 Feb 2009 12:43:33 -0500
What exactly is slow?
Context is used to search within lobs - probably not relevant here.
Try caching the lob.
alter table <table> modify lob (lob_name) (cache);
On Thu, Feb 12, 2009 at 11:40 AM, Ben Wittmeier <Ben.Wittmeier@xxxxxxxxx> 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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
