--> outcome eacht time query ran fast

From: Stephan <test_at_test.com>
Date: Sun, 05 Jan 2003 19:09:09 GMT
Message-ID: <pp%R9.16$P32.2544@nlnews00.chello.com>

---

---

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

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

---

Parse 54 0.09 0.09 0 0 0 0
Execute 27 0.04 4.68 0 81 243 0
Fetch 27 0.03 13.95 0 162 108 81
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 108 0.16 18.72 0 243 351 81

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

---

---

---

---

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

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

---

Parse 56 0.09 0.09 0 0 0 0
Execute 28 0.04 4.71 0 84 252 0
Fetch 28 0.03 14.08 0 168 112 84
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 112 0.16 18.88 0 252 364 84

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

---

---

---

---

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

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

---

Parse 58 0.10 0.10 0 0 0 0
Execute 29 0.04 4.73 0 87 261 0
Fetch 29 0.03 14.11 0 174 116 87
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 116 0.17 18.94 0 261 377 87

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

---

---

---

---

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

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

---

Parse 60 0.10 0.10 0 0 0 0
Execute 30 0.04 4.74 0 90 270 0
Fetch 30 0.03 14.14 0 180 120 90
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 120 0.17 18.98 0 270 390 90

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

---

---

---

---

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

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

---

Parse 62 0.10 0.10 0 0 0 0
Execute 31 0.04 4.79 0 93 279 0
Fetch 31 0.03 14.17 0 186 124 93
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 124 0.17 19.06 0 279 403 93

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

---

---

Received on Sun Jan 05 2003 - 13:09:09 CST