RE: Philosophical question on primary keys
- From: Randolf Geist <info@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 12 Aug 2009 12:04:03 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
