Indexing a CLOB
- From: "Ben Wittmeier" <Ben.Wittmeier@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Feb 2009 09:40:59 -0700
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
Other related posts:
