Re: reducing LIO's

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 31 Mar 2005 21:47:39 -0500
Message-ID: <f09dd6280503311847660190d5@mail.gmail.com>

Thomas,
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 performance?

On Thu, 31 Mar 2005 09:42:30 -0500, Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 31 2005 - 21:51:30 CST