SLOW QUERY EXECUTION

SLOW QUERY EXECUTION

 

  


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