What is the query? Also check to make sure compression is not on the DB
tables. I ran into a site where that happened once and performance suffered
(probably not your problem, but might as well check). Also what indexes are
on the table.
Jim
"Christian Greven" <greven.christian_at_baufeldt.de> wrote in message
news:8vlfop$hkl$03$2_at_news.t-online.com...
>
> Barbara Kennedy <barbken_at_teleport.com> schrieb in im Newsbeitrag:
> pG7T5.13641$pZ1.805009_at_nntp3.onemain.com...
> > Yes, and what is the explain plan in both cases.
>
>
> After analyze on both systems says the explain plan: Full scan on all
> tables.
>
> Before some indexes have been used. There are good indexes for this
> sql-statement.
>
> Bye,
> Christian.
>
>
>
>
>
>
Received on Fri Nov 24 2000 - 09:41:25 CST
