clustered index.

clustered index.

 

  

Gurus,
I need to create a clustering index. I know I can create only one
clustered index on a given table. But, can this clustered index include
multiple columns? I am not planning to include primary key in this
column list as I know I would need to do this while creating table.
When I refer to syntax for creating clustering index, I am not getting
it right. There are no examples that I could find to create clustering
index from a clp.
Any input would be v useful.
Version: DB2 V8.2
Thanks.

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