Re: Oracle Text Design Question

Phew!

Okay, after much time rebuilding everything and reanalyzing indexes etc. etc. I've executed my query and it came back in milliseconds! I haven't completed gathering stats yet, but at least I know now that this is possible and I'll try to get as much information about the current state as possible.

Next step is to build a new index and run the analysis over the weekend on the production Alpha server.
I don't want to do anything drastic to my production server, so I'll not be gathering stats for the whole schema as I did in this test, rather I will start off with just the tables and indexes that are associated with the Text index. After this I will gather stats for tables/indexes one by one.

It definitely seems that the analysis was what solved this problem.

Thanks for all your help Giovanni, I was beginning to doubt the usefulness of Oracle Text.

"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message news:3c4raoF6mcp2qU1_at_individual.net...
> Hi Kevin,
>
> I forgot to mention ... please remove every non Oracle
> Text parts out of your query i.e. table joins to really
> isolate the problem ...
>
> Please run all tests and benchmarks on the Oracle Text
> query only.
>
> Best Regards,
> Giovanni
>
>
Received on Fri Apr 15 2005 - 05:32:55 CDT