RE: Table with 300 columns (ie > 255) : Row Chaining ?
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>, <Timothy.Hopkins@xxxxxxxxxxxxxxxxxxx>
- Date: Mon, 26 Oct 2009 23:52:47 +0800
Some (more ?) surprising
results at
http://hemantoracledba.blogspot.com/2009/10/some-more-testing-on-intra-block-row.html
And I haven't started with tables with more than, say, 512 columns.
Furthermore, I haven't yet obtained statistics on DML impact on redo
sizes, as Timothy has pointed out.
These tests are out of what I found as unconvincing performance
statistics when comparing queries on large (>400 columns) FACT Tables
-- eg queries that are aggregates against single columns of the table.
Hemant K Chitale
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
