SEO

#1 (**permalink**) 05-05-2008, 05:51 AM

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.

#2 (**permalink**) 05-05-2008, 05:51 AM

"Michel Esber" <michel@us.automatos.com> wrote in message
news:5da03187-b4b6-4604-84e1-8c6bf087eda3@m3g2000hsc.googlegroups.com...
> 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 important 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Question about tablespace design