Re: IOT Vs Normal Tables

From: jared still <jkstill_at_teleport.com>
Date: Wed, 13 Dec 2000 20:35:00 -0800 (PST)
Message-Id: <10709.124523@fatcity.com>

On Wed, 13 Dec 2000, Sanjay Kumar wrote:

> Hi,
>
> Can anyone tell me how to see the performance differences of using IOTs over the normal tables.
>
> Sanjay
>

I don't think you will see any performance increase from an IOT.

You can get the same performance if your query can be satisfied by an index without reading the table. i.e. the index has all the columns to satisfy the query.

IOT's just save space and complicate your life. :)

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com
jared_still_at_enron.net Received on Wed Dec 13 2000 - 22:35:00 CST