Re: --> outcome of almost same query

From: Stephan <test_at_test.com>
Date: Mon, 06 Jan 2003 21:41:22 GMT
Message-ID: <6KmS9.12$7Q3.292@nlnews00.chello.com>

Hi, when I run the query using district2 table (created by means of: "select * from district") the performance
is always ok.

See below, I also ran it 31 times. The explain plan is much simpler, I do not know why???

regards
Stephan

select id_district district_id, district_name FROM district2, district_street where
(district_id=id_district) AND (place_street_id=707)

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ------

Parse 62 0.15 0.27 0 225 0 0
Execute 31 0.01 0.05 0 0 0 0
Fetch 31 0.06 0.15 9 341 496 93
------- ------ -------- ---------- ---------- ---------- ---------- ------

total 124 0.22 0.47 9 566 496 93

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 20 (PREVENT)

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   HASH JOIN
      0    INDEX   GOAL: ANALYZED (FAST FULL SCAN) OF 'DISTRICT_STREET_4'
               (NON-UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'DISTRICT2'






****************************************************************************

Received on Mon Jan 06 2003 - 15:41:22 CST