Index-Organized Tables

From: Erik <ecotsonas_at_saraswati.com>
Date: Fri, 02 Jul 1999 13:19:16 GMT
Message-ID: <7lie8b$bb1$1@nnrp1.deja.com>

Does anyone have any real world experience with Index-Organized tables?

I have 2.5GB of data. A B*Tree index on the primary key uses about 2.2GB. It is currently partitioned on a date column for quarters and there are a couple of secondary indexes.

I am going to test converting this to an index-organized table, and was just looking for feedback from anyone who might have done something like this already.

Known drawbacks:
I know you can't create secondary bitmap indexes and secondary index queries don't execute in parallel currently.

Any pros/cons would be great.

--
Erik
Consultant
Saraswati Systems Corporation - (SSC)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 02 1999 - 08:19:16 CDT