Re: Indexing a CLOB
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Ben.Wittmeier@xxxxxxxxx
- Date: Thu, 12 Feb 2009 17:37:45 +0000
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@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
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
