Page size for Indexes on large tables in a Data...

Main Page | Report this Page

Computers Forum Index » Computer - Databases - IBM DB2 » Page size for Indexes on large tables in a Data...

Page 1 of 1

Page size for Indexes on large tables in a Data...

Author

Message

Mark A...

Posted: Mon Oct 19, 2009 12:20 am

Guest

DB2 9.7 for Linux with DPF. I normally use 32K page size for large tables
(100's of millions of rows) in a data warehouses (4K for small reference
tables). Any problem in using 32K page size for indexes on the large tables
in a data warehouse? Tablespaces are defined as large.

Page 1 of 1

All times are GMT The time now is Tue Dec 01, 2009 10:15 pm Computers Forum Index