performance

From: Stephan <test_at_test.com>
Date: Mon, 30 Dec 2002 17:32:25 GMT
Message-ID: <Jq%P9.23$Ua7.11811@nlnews00.chello.com>

Oracle 8.1.7 NT2000:

Running 2 databases on the same machine, 'same' init parameters.

in database 1 I imported the full user-scheme (say 30 tables).
in the database 2 I imported only 2 tables of that user-scheme (one having 20 records, the other 2000).
- When I select from database 2 by means of: "select id_district, district_name FROM district, district_street where (district_id=id_district) AND (place_street_id=707)" the performance is good.
- Running the same query against database 1 gives very poor performance: 2 seconds for retrieving the 3 records!!

The explain-plan for the querie is the same on datab1 and datab2. SELECT STATEMENT Cost = 3

HASH JOIN

            TABLE ACCESS FULL DISTRICT
            INDEX FAST FULL SCAN DISTRICT_STREET_UNIQUE

When I drop all objects from database 1 execept the 2 tables, the performance stays poor....

Please help me!

Thanks
Stephan Received on Mon Dec 30 2002 - 11:32:25 CST