--> outcome of running same query several times

From: Stephan <test_at_test.com>
Date: Sun, 05 Jan 2003 18:33:22 GMT
Message-ID: <ST_R9.88$%_1.24994@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 12 0.02 0.02 0 0 0 0
Execute 6 0.00 2.84 0 18 54 0
Fetch 6 0.01 4.64 0 36 24 18
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 24 0.03 7.50 0 54 78 18

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 14 0.02 0.02 0 0 0 0
Execute 7 0.00 2.91 0 21 63 0
Fetch 7 0.01 4.67 0 42 28 21
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 28 0.03 7.60 0 63 91 21

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 16 0.02 0.02 0 0 0 0
Execute 8 0.00 2.93 0 24 72 0
Fetch 8 0.01 4.70 0 48 32 24
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 32 0.03 7.65 0 72 104 24

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 18 0.03 0.03 0 0 0 0
Execute 9 0.01 2.95 0 27 81 0
Fetch 9 0.01 4.73 0 54 36 27
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 36 0.05 7.71 0 81 117 27

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 20 0.04 0.04 0 0 0 0
Execute 10 0.01 2.97 0 30 90 0
Fetch 10 0.01 4.76 0 60 40 30
------- ------ -------- ---------- ---------- ---------- ---------- ------

---

total 40 0.06 7.77 0 90 130 30

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

---

---

Received on Sun Jan 05 2003 - 12:33:22 CST