jctgf Currently Banned Active User
Joined: 04 Nov 2006 Posts: 109
|
|
|
|
hi,
I have a doubt about the "partitioned index" concept, please.
Until version 7, I used to believe that a partitioned index was the index that defined the partitioning of the table. The partitioned index also had to be a cluster index and there could only be one partitioned index per table. The partitioned index, just like the data area of the table, was also partitioned, and had the same number of partitions of the table.
Now, I'd like to know what is a "partitioned index" in DB2 version 8, please. Does it have the same meaning, characteristics and purpose than the one in the older versions? How many partitioned indexes are possible, for the same table, in V8? In V8, can I have a partitioned index that defines the partitioning criteria for the table and many other partitioned indexes, that are partitioned only to make the maintenance of the table faster? Until V7, a partitioned index had to be a cluster one. Is it the same in V8?
Thanks. |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
At the top of the page is a link to "IBM Manuals". Among them is the DB2/UDB V8 SQL Reference. In that manual look at least at CREATE INDEX, 5.31.
There is no reason for someone here to read the manual for you and repeat it here.
If you find something in the manual that is not clear, post what you found and your doubt about it. Someone will be able to clarify. |
|