Не заглядывал раньше на developerworks. А теперь вдруг в письме http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=5raAc.48687%24eu.47179%40attbi_s02
я увидел ссылки:

http://www-106.ibm.com/developerworks/db2/library/techarticle/0204pooloth/0204pooloth.html
http://www-106.ibm.com/developerworks/db2/library/tips/dm-0403wilkins/index.html#appendixb
http://www7.software.ibm.com/vadd-bin/ftpdl?1/vadc/dmdd/db2/dm-0312stolze/0312stolze.pdf
http://www-106.ibm.com/developerworks/db2/library/tips/dm-0312yip/index.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/0310wilkins/0310wilkins.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/0306arocena/0306arocena.html
http://db2mag.com/db_area/archives/2003/q2/welgan.shtml
http://www.db2mag.com/db_area/archives/2003/q2/deng.shtml
http://www.redbooks.ibm.com/redbooks/SG246917/css/SG246917_bmark.html#
http://www-106.ibm.com/developerworks/db2/library/techarticle/0303kuznetsov/0303kuznetsov.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/0302kuznetsov/0302kuznetsov.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/0301mullins/0301mullins.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/0208kuznetsov/0208kuznetsov.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/0208zubiri/0208zubiri.pdf
http://www-106.ibm.com/developerworks/db2/library/techarticle/0203milligan/0203milligan.html

Журнальчик
http://]http://www.databasejournal.com/features/db2/
с кучей интересных статей.

Так, что ли?
http://www.databasejournal.com/features/db2/

Ох уж эти статьи...

Читаю

http://www.dbazine.com/mullins_db2indexing.shtml

Indexing Variable Columns

Prior to Version 8, when indexing on a variable column, DB2 automatically pads the variable column out to its maximum size. So, for example, creating an index on a column defined as VARCHAR(50) will cause the index key to be padded out to the full 50 bytes. Padding poses several problems. You cannot get index only access with a padded index because DB2 will always have to access the table space data to retrieve the actual size of each column.

А я и не знал, что index only access был невозможен для varchar... Про padding в принципе знал, но думал, что, тем не менее, они как-то выкручиваются.


С другой стороны, слова PADDED в моем хелпе нет. Уж ли не про мейнфреймовую DB2 идет речь??? И это:

An index is created using the CREATE INDEX statement, which is similar in several ways to the CREATE TABLESPACE statement. Both require the user to specify storage (USING, PRIQTY and SECQTY), free space (PCTFREE and FREEPAGE), a buffer pool (BUFFERPOOL), and how to close the underlying data sets (CLOSE). However, there are also many differences.

и это

CREATE INDEX XEMP2 ON DSN8710.EMP (EMPNO ASC) USING STOGROUP DSN8G710 PRIQTY 36 ERASE NO CLUSTER (PART 1 VALUES('H99'), PART 2 VALUES('P99'), PART 3 VALUES('Z99'), PART 4 VALUES('999')) BUFFERPOOL BP1 CLOSE YES COPY YES;

И все понятно. Меня подло обманули.