RE: Table with 300 columns (ie > 255) : Row Chaining ?

From: Hemant K Chitale <>
Date: Mon, 26 Oct 2009 23:52:47 +0800
Message-Id: <>

Some (more ?) surprising
results at

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

-- Received on Mon Oct 26 2009 - 10:52:47 CDT

Original text of this message