| Computers Forum Index » Computer - Databases - IBM DB2 » Difference in INDEX statistics in SYSIBM.SYSINDEXES... |
|
Page 1 of 1 |
|
| Author |
Message |
| dibalok at (no spam) gmail.com... |
 Posted: Wed Oct 28, 2009 5:37 pm |
|
|
|
Guest
|
Hi,
I am encountering a strange problem for a Table in production vs test.
The table has same number of records in both test and production. It
has 5 indexes and SYSIBM.SYSINDEXES shows CLUSTERED=Y for the first
index in production while in test CLUSTERED=Y shows up for the first
three index.
The production table goes thru REORG-RUNSTAT-BIND every Sunday and is
then copied over to test followed by a RUNSTAT in test. I wonder what
makes DB2 assign CLUSTERED=N to a index in prodcution but CLUSTERED=Y
to the same Index in test.
Index Name CLUSTERING CLUSTERED in Production CLUSTERED in Test
----------------------------------------------------------------------------------------------------------------------
IXHB1 Y Y Y
IXHB2 N N Y
IXHB3 N N Y
IXHB4 N N N
IXHB5 N N N |
|
|
| Back to top |
|
|
|
|
