RE: Philosophical question on primary keys

From: Randolf Geist <>
Date: Wed, 12 Aug 2009 12:04:03 +0200
Message-Id: <>


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
Received on Wed Aug 12 2009 - 05:04:03 CDT

Original text of this message