"Stephan" <test_at_test.com> wrote in message news:<6KmS9.12$7Q3.292_at_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'
>
> ***************************************************************************
>
Simplier than what? What is the question/problem?
Received on Tue Jan 07 2003 - 09:43:17 CST
