HI!!


in new in DB.

a script in which creation of tables & indexes is taking too much time for
execution.

it creates 11 tables(TMP1 tables from exsiting tables using"create table as
select * from.........TMP table) & 22 indexes on these TMP1 tables.

& nothing else is done in this script.

Can anyone sugegst me the reason why & how to make it run more fast.

Thanks & Best Regards
Reema






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