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?
Thanks.
|
|
|