RE: Philosophical question on primary keys

From: Randolf Geist <info_at_sqltools-plusplus.org>
Date: Wed, 12 Aug 2009 12:04:03 +0200
Message-Id: <756303053_at_web.de>

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

Received on Wed Aug 12 2009 - 05:04:03 CDT