Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index ?
- 3 Answers
- 7627 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Clustering index determines where the row will be inserted.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / saeed
clustering index attempts to maintain a particular order of
data, it try to keep newly inserted rows clustered
according to an index and avoid page splits.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mainframe.rahulz
A DB2 index is a clustering index if the CLUSTER keyword is
specified when the index is created.In a clustered index
rows are stored continuously in a an
order.
When you define a clustering index on a DB2 table, you
direct DB2 to insert rows into the table in the order of the
clustering key values. The first index that you define on
the table serves implicitly as the clustering index unless
you explicitly specify CLUSTER when you create or alter
another index. For example, if you first define a unique
index on |the EMPID column of the EMP table, DB2 inserts
rows into the EMP table in the order of the EMPLOYEE ID
unless you explicitly define another index to be the
clustering index
Eg:CREATE INDEX Index name
ON tablename CLUSTER;
| Is This Answer Correct ? | 0 Yes | 0 No |
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Can I use LOCK TABLE on a view?
What is netezza database?
is there any restrictions for unions ?
What is db2 stogroup?
What is iseries database?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Explain about open switch business continuity software?
What is Call attach facility? How does it work?
What is isolation level?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
COBOL 
