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 |
What is the format (internal layout) of ?TIMESTAMP??
can any body explain about plan and pakage in detail....
Define declaration generator (dclgen).
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
How would you find out the total number of rows in a db2 table?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
what is the difference between where clause and having clause
What is copy book?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
why we go for SPUFI for creating tables or for sql queries?
What is plan in cobol db2?
Write a query to retrive partial string.