Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Migrating Data Using Siebel EIM > Considerations for EIM Tables >

Updating the S_LST_OF_VAL Table

---

The BU_ID column in the S_LST_OF_VAL base table can have only one or very few distinct values. When this happens, the DB2 optimizer often needlessly performs a table scan through all rows in the S_LST_OF_VAL table.

To avoid this problem and speed up the query, modify the statistics data by running the following SQL statements:

update sysibm.sysindexes set firstkeycardf=1000 where

name='S_LST_OF_VAL_M2';

update sysibm.syscolumns set colcardf = 1000 where

tbname='S_LST_OF_VAL' and name='BU_ID';

NOTE:  Depending on the data you are working with, you might need to run other SQL statements ahead of time.

Bookshelf Home | Contents | Index | Search | PDF