RE: Philosophical question on primary keys
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:
> 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 Received on Wed Aug 12 2009 - 05:04:03 CDT