RE: Table with 300 columns (ie > 255) : Row Chaining ?
Date: Mon, 26 Oct 2009 23:52:47 +0800
Some (more ?) surprising
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://www.freelists.org/webpage/oracle-l Received on Mon Oct 26 2009 - 10:52:47 CDT