Re: Intermedia queries slow any ideas?

Yes, checked autotrace and domain index is being used. Anymore ideas??

There is a join involved with headers and messages by an ID which is index and set to foreign key in the messages table. I dont think that should cause any problems. Also the messages table only has two columns, HeaderId and Message(CLOB).

I wanted to split the headers from the messages. Should I flatten this out and put everything into one table? The messages table will grow to well over 1,000,000 records as will the header table.

It is a one to one join between the two tables.

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:36:59 CDT