Re: Intermedia queries slow any ideas?

Thanks I will give that a try. I have analyze schema compute statistics but havent tried delete statistics.

The domain index? Need to check. Thanks,

Kev.-

On Tue, 10 Apr 2001 12:03:54 GMT, "timkarnold" <timkarnold_at_home.com> wrote:

>1. Is the query using the domain index? set autotrace on
>2. Try either analyze schema compute statistics or delete statistics.
> We found that deleting statistics was beneficial.
>
>"Kev.-" <java2e_at_yahoo.com> wrote in message
>news:3ad2deb4.174556238_at_ns1.nothingbutnet.net...
>> Hello I am trying to user Intermedia but it is extremely slow.
>>
>> For example I have about 40,000 records that are in a CLOB column.
>> When I do a search with the contains it takes for ever to return the
>> results. How can I speed this up? I have tried updating statistics,
>> etc... I cannot seem to make it speed up.
>>
>> It I choose say the word plsql it can take almost a minute +. I dont
>> understand because if I go to a search liek groups.google.com it
>> is like it is running on my local machine. How can I obtain that
>> speed?
>>
>> Oracle ver 8.1.7
>> NT Server 4 service pack 5
>> 756 megs ram.
>>
>> Anyone?
>
>
  Received on Tue Apr 10 2001 - 16:31:46 CDT