- Is the query using the domain index? set autotrace on
- 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 - 07:03:54 CDT
