RE: Philosophical question on primary keys

Jay,

in that particular case if you have that huge columns leading to row chaining 
then the unique "vertical" partitioning option of IOTs using overflow segments 
might actually give you a significant advantage, of course depending on how 
these huge columns are getting used.

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/

> Changing secure_inbox_message an iot while intriguing might actually
> yield lower performance than just creating the index on the 2 columns
> whose data is being retrieved.  This is because there is some row
> chaining (not just migration) in that table due to some huge columns so
> using an iot has the potential of increasing the lios.

______________________________________________________
GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://movieflat.web.de

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


Other related posts: