high parse/execute ratio

From: <tony_guo_at_iname.com>
Date: Tue, 24 Oct 2000 13:07:23 -0400 (EDT)
Message-Id: <10659.120056@fatcity.com>

I have a select statement called by java as follows: SELECT
  b.login,
  a.user_id,
  (sum(a.score)+100) as highscore
FROM
  score_table a,
  member_table b
WHERE
  b.member_id(+)=a.user_id
group by a.user_id,b.login order by highscore desc

It was executed for 563895 times, parsed for 563895, buffer gets 438919180, disk reads 105716809, first loaded on 10/19. How bad is this? What can I do about it?

TIA
tony

---

Get free email from CMP at http://www.cmpnetmail.com/ Received on Tue Oct 24 2000 - 12:07:23 CDT