Re: Oracle speed issues
From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Tue, 06 Jul 1999 18:37:13 GMT
Message-ID: <t1sg3.55690$Fz2.7928_at_news.rdc1.az.home.com>
Date: Tue, 06 Jul 1999 18:37:13 GMT
Message-ID: <t1sg3.55690$Fz2.7928_at_news.rdc1.az.home.com>
Jack Toering <71045.3122_at_compuserve.com> wrote in message news:uMrLlZ7x#GA.176_at_nih2naae.prod2.compuserve.com...
<snip>
> Dropping indexes on the Oracle or MSSQL tables make no difference in
speed.
> Dropping the indexes in SQLAnywhere makes a huge difference in speed in
the
> first example, and no difference in speed in the JOIN.
>
Then, obviously, Oracle is not using the indexes, or the speed would change dramatically. So, either you have the rule-based optimizer turned off and there are no statistics on the tables you're querying, or the indexes don't match the queries. I'd bet it's the former. Received on Tue Jul 06 1999 - 20:37:13 CEST