Hi All,
Is there any particular advantage in having larger page
sizes for data warehousing environment over smaller pagesizes. For
example, is it better to have a 32 K page instead of an 8K page in
favor of faster sequential scans even though larger page size may
waste disk space?

Thanks.

On 11 Cze, 16:48, Asphalt Blazer <asphaltbla...@gmail.com> wrote:
> Hi All,
> Is there any particular advantage in having larger page
> sizes for data warehousing environment over smaller pagesizes. For
> example, is it better to have a 32 K page instead of an 8K page in
> favor of faster sequential scans even though larger page size may
> waste disk space?
>
> Thanks.

In general, in data warehousing environment you can lower number of
IOs by using larger pages sizes (this is based on an assumption, that
executed queries will use the rest of rows on the page -- sequential
scan nature).

If you have few big tables which are not updated frequently you will
not observe wasting disk space.

-- Artur Wronski

Artur wrote:

> If you have few big tables which are not updated frequently you will
> not observe wasting disk space.

Generally this is the case, but be cognizant of potential risks if you
have short row lengths (hitting 255 row/page limitation, unless you
have large table spaces) or if you are using MDCs.