Home » Server Options » Text & interMedia » Creating an Intermedia Index
Creating an Intermedia Index [message #366447] Wed, 23 August 2000 19:41
Richard Lau
Messages: 1
Registered: August 2000
Junior Member
I need to create a intermedia index on a 2 million row table.
The index will be created using a concatenated datastore which
will combine 10 columns from the table. So far, running with
parallelism of 4, the create index is taking more than 3 hours.

(a) Is there a way to speed this up or an offline process I should
be aware of ?

(b) Any suggestions on efficient updates to any of the 10 columns?

Previous Topic: Object_Option
Next Topic: getting error ora-29855 AND Error while creating Index on clob data (2 threads merged by bb)
Goto Forum:

Current Time: Wed Aug 23 07:06:05 CDT 2017

Total time taken to generate the page: 0.04682 seconds