RE: Philosophical question on primary keys

  • From: Randolf Geist <info@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 12 Aug 2009 12:04:03 +0200


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.


Oracle related stuff blog:

SQLTools++ for Oracle (Open source Oracle GUI for Windows):

> 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


Other related posts: