I tried doing IMPORT of roughly 1.7 million rows with and without
index on the following table . With index it went through in 15 mins
and the same IMPORT without the index took 13 mins.
Is that all the performace difference we can expect from DB2 ??
We are at the base level of DB2 7.1 on Solaris.
Thanks in advance.
CREATE TABLE TAB1
C10 SMALLINT NOT NULL DEFAULT 1024,
C11 TIMESTAMP NOT NULL WITH DEFAULT
) in TS1 index in TS2 ;
CREATE INDEX IND1 ON TAB1(C1, C3,C4
, C5) CLUSTER