Re: Question on reorgs with a clustering index

Re: Question on reorgs with a clustering index

 

  





No if you dont use indexscan for a clustered index, it will do a sort in
memory.







"Gerald Larose "
<db2udbdba-ezmlms
hield-x98267340.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
02/25/2005 01:07
PM Subject
Question on reorgs with a
clustering index










Running DB2 version 8.1.1 on AIX 5.1.1

The table (employee) is being reorged and has a clustering index (empid).

Is there any different between these two commands?

db2 reorg table employee index empid allow no access indexscan

db2 reorg table employee index empid allow no access

Thanks
Gerry








---------------------------------------------------------------------
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