Don't forget faster performance on the READ as your data is right there
instead of finding the row_id on the index then find it again.

Allen Chan


-----Original Message-----
From: Seefelt, Beth [mailto:Beth.[Email Address Removed] Friday, January 31, 2003 11:33 AM
To: LazyDBA.com Discussion
Subject: RE: IOT table benefits



The quantifiable gain is in space.

If you have a 90M row table with 18 byte rows, and, say, one index which
includes both columns, it'll require 36*90M bytes .

If you use an IOT instead, it will be just 18*90M bytes.



-----Original Message-----
From: James.D.[Email Address Removed] [mailto:James.D.[Email Address Removed]
Sent: Friday, January 31, 2003 1:23 PM
To: LazyDBA.com Discussion
Subject: IOT table benefits


Hi all,

Anyone know of any documentation of quantifiable gains using an IOT vs a
regular table? The table in question is a 90,000,000 row 2 column
table
with each column being a 9 character field.

Thanks,

Jim



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page