Query Question - Fetches

From: Arthur <amerar_at_iwc.net>
Date: 17 Nov 2004 07:01:07 -0800
Message-ID: <8b622eae.0411170645.44bf1d7d@posting.google.com>

Hi All,

I had a query that ran forever. I ran TKPROF on it and as you can see it had some serious issues:

call     count       cpu    elapsed       disk      query    current  
     rows

------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        1      0.00       0.00          0          0          0  
        0
Execute      1      0.00       0.00          0          0          0  
        0
Fetch       19    829.14     853.59       2447     139764         13  
      256

------- ------ -------- ---------- ---------- ---------- ----------

---

total       21    829.14     853.59       2447     139764         13  
      256

The query had LOTS of RTRIM functions. Once I removed the RTRIM function calls the number of fetches drop significantly:

call     count       cpu    elapsed       disk      query    current  
     rows

------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        1      0.00       0.00          0          0          0  
        0
Execute      1      0.00       0.00          0          0          0  
        0
Fetch       19      5.36       6.17       2119     616256         12  
      256

------- ------ -------- ---------- ---------- ---------- ----------

---

total       21      5.36       6.17       2119     616256         12  
      256

So, my question is: Why do the function calls raise the number of fetches?

Thanks,

Arthur Received on Wed Nov 17 2004 - 09:01:07 CST