by "Mark A" <nobody@[EMAIL PROTECTED]
>
May 4, 2008 at 01:51 AM
"Michel Esber" <michel@[EMAIL PROTECTED]
> wrote in message
news:5da03187-b4b6-4604-84e1-8c6bf087eda3@[EMAIL PROTECTED]
> Hi all,
>
> DB2 LUW v8 FP15
>
> Is there any performance overhead if a table is created on data and
> index tablespaces with different page sizes ?
> What kind of penalty is expected ?
>
> Sample Layout:
>
> BufferPool A (pagesize 16K) -> Tablespace A (pagesize 16k)
> BufferPool B (pagesize 8K) -> Tablespace B (pagesize 8k)
>
> create Table a ( several fields ) in A index in B;
>
> Thanks in advance, Michel.
There is no absolutely no performance penalty in using different page
sizes
for the table and indexes.
The most im****tant factor is that the page size:
1. Is appropriate for the row size,
2. Is appropriate for the type of application (use smaller page size for
OLTP and larger page size for data warehouses), and
3. The tablespace is assigned to a bufferpool with a sufficient number of
pages to keep the bufferpool hit ratio high.
