Re: Oracle performance

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 27 Apr 2001 11:46:10 +0100
Message-ID: <988368432.14603.0.nnrp-07.c30bdde2@news.demon.co.uk>

"Thomas Waenke" <twaenke_at_maps-geosystems.com> wrote in message news:9cbg9l$bvr$1_at_broadway.news.is-europe.net...
> Andrew,
>
> thanks for your quick response. I analyzed my statement and found the
> mistake.
> The problem was that " (select .... from t1 ....where ..)" should read
> "select ....from t1,t2...where..."). I do not know much about Oracles
> internals, but it seems that the missing table t2 in the 'from' clause
> causes a lot of overhead. Much more than on MSSQL or Access.
> Now it takes less than 1 sec. to produce the result.
>

That's a pity - if it was three times faster, you could have got $1m from Oracle... ;-) Received on Fri Apr 27 2001 - 05:46:10 CDT