Choosing an Ordering Method for Best Table Compression

Some comments here: http://www.phpbbserver.com/phpbb/viewtopic.php?t=614&mforum=dizwellforum

Advertisements

5 thoughts on “Choosing an Ordering Method for Best Table Compression

  1. I wrote myself a little PL/SQL procedure which takes the following:

    OWNER
    TABLE NAME
    PARTITION_NAME
    SAMPLE SIZE

    and builds a set of temp tables which are ordered by each column in the given table using the sample size. It then returns the number of blocks/rows/space used in each ordering method so that I can determine the individually best column compression orders based on empirical data. You can then choose the best column(s) to order your data by – I consider both the most compressable order by column(s) and the most used access path column(s) depending on the requirement.

    Code available on request….might stick it on my blog…

  2. I’ve extended the code as you suggested – can supply prefix columns that you know are common access path(s) and it works out the compressability of all the other columns when appended to the given prefix columns in the ORDER BY. Let me know what you think whenever you get time to try it.

  3. 1000 форумов 2 доллара 5000 форумов 8 долларов 10000 форумов 13 долларов 50000 форумов 50 долларов
    Бонус предложение для тех кто закажет 20000 форумов через неделю повторная отправка
    Рефпредложение: человек который приведет мне клиента будет получать 10% от заказа клиенка!!!
    Обращаться в асю 3пять3-8шесть7-0ноль1 мыло anhelluss(гав)yandex.ru

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s