What is a clustering index ?
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 |
where can we use index and subscript ? with example ?
What is database reorganization?
What is the meaning concurrency in the db2 database?
how to take the back up of the DB2 table.
How to fetch the last row from the table in SQL (db2)?
what is sql abend code -801,-802?
Where is the access path logic created by the DB2 Optimizer stored?
What is the function of buffer manager?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What if we fail to give values in columns declared as NOT NULL ?
What is meant by index cardinality?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM