Re: reducing LIO's

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: thomas.mercadante@xxxxxxxxxxxxxxxxx
  • Date: Thu, 31 Mar 2005 21:47:39 -0500

I have a similar situation(query) and needs performance improvement.
My understanding is that IOT is good for lookup tables.  Can I use IOT
for transaction tables(gets updated every few mins).

Did anyone try clustering the tables involved in joins to improve the

On Thu, 31 Mar 2005 09:42:30 -0500, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> I agree.  I reduced a very slow OLTP summary query from 3 minutes to 5
> seconds using an IOT.  This query was used every time a user hit their home
> page.

Other related posts: