Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index ?
- 3 Answers
- 7550 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 use of bind parameter, Replace?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are the prerogatives?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
Mention the different locking levels that are available in db2.
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Is db2 a mainframe?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What r the comman abends in db2, jcl and cobol???????
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
COBOL 
