Oracle performance

From: Thomas Waenke <twaenke_at_maps-geosystems.com>
Date: Fri, 27 Apr 2001 10:10:55 +0200
Message-ID: <9cb9fe$a17$1@broadway.news.is-europe.net>

Hi,

we use Oracle 8, MS SQL Server 7 and MS Access 97. When I send a SQL query of the form "SELECT * FROM table1" I get the result
(10000 rows) within 1 second in any of the three environments.
Now I have the following query:

select * from t1 where id in
(SELECT t2.id From t2 where t2.id = t1.id group by mgk_struct.pid)

This query runs 2 seconds on MSSQL7 and MSAccess but 2 minutes on Oracle! Where is the problem?
Is there a general and easy way to check Oracles performance?

Thanks,

Thomas Waenke
MAPS geosystems,Munich Received on Fri Apr 27 2001 - 03:10:55 CDT