Question on reorgs with a clustering index

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







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