Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index ?
- 3 Answers
- 7370 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 |
What is the role of data manager in the db2 database?
What is a cursor in programming?
When reorg is used?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What DB2 Catalog column tell you when an index needs table reorganized ?
What should be specified along with a cursor in order to continue updating process after commit?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is DYNSLT keyword? How do you perform selection using DYNSLT
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is a thread?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
COBOL 
