Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
many doubts about "partitioned index"

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jctgf
Currently Banned

Active User


Joined: 04 Nov 2006
Posts: 109

PostPosted: Sun May 24, 2009 5:16 am    Post subject: many doubts about "partitioned index"
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 24, 2009 6:53 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us