turn on intra-parallelism






"divakar"
<db2udbdba-ezmlmshield-x62620681.[Email address protected] To:
om> "LazyDBA Discussion"
<[Email address protected]
cc:
Monday May 23, 2005 11:47 AM Subject: Index Creation







We are creating indexes on Tables with about 20 million records. But the
each index creation is taking between 12 - 15 min. Is there a way to
speed this up. How can I enable parallelism while index creation. Same
is happening in case of primary key creation.




We are using db2 udb ver 8.2 for Unix.




Divakar





Confidentiality Notice


The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[Email address protected] immediately
and destroy all copies of this message and any attachments.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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