Yes, you can include multiple column.

Syntex is very simple, just add cluster to the create index syntex:

Create index index_name on tablename (c1,c2,c3,...) cluster

-----Original Message-----
From: Kristipati Pavan
[mailto:db2udbdba-ezmlmshield-x46386652.[Email address protected]
Sent: Thursday, October 19, 2006 3:24 PM
To: LazyDBA Discussion
Subject: 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.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

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