Re: Context option, v7.3.4, build index

From: Robert H. Thompson <rthomp41_at_ford.com>
Date: Fri, 30 Apr 1999 15:58:46 -0400
Message-ID: <372A0B76.7AED73EF@ford.com>

Are you using something like this:

exec
ctx_ddl.create_index('TEST_PLCY'); exec
ctx_ddl.optimize_index('TEST_PLCY',ctx_ddl.defragment_to_new_table);

this usually optimizes the index to its best performance. although knowing something about the hardware and number of users helps too. I use this on
policies for storing environmental data from 250+ countries for an auto company. Performance is pretty good on Sequent boxes.

Hope this helps

Rob Thompson

DBA - Ford Motor
Company

Jonathan Lewis wrote:
>
> Does any user of Context have any hints on getting
> the best performance out of ctx_ddl.create_index
>
> I have about 150,000 documents of ca. 10K each
> for a total documentation size of 2.7 GB
>
> Answers to email address preferred, I will summarise
> for the group.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Received on Fri Apr 30 1999 - 14:58:46 CDT