Hi all,



I have two tables one with have 2 records and one with 23 records.
Actually now we are migrating data from fast database to DB2. So these 2
tables will grow enormously in future. We have created indexes for these 2
tables. But in the performance I found when I remove the indexes its
performing better than that with the indexes. Can anybody explain why it is
happening?



Since the table has few data it's taking very less time to read sequentially
than reading through index scan. But I read somewhere that the DB2 optimizer
should choose accordingly so that if there are less number of records go for
sequential read or go for index scan. If it is the case whether I need to
change any parameter to handle this?



Regards,

Ruben


DB2 & UDB email list listserv db2-l LazyDBA home page