What is a clustered index?

Answer Posted / pradeep

a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence

datarows will be arranged based on the index in leaf pages

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 table?

597


what is the role of the cursor in db2?

643


What is reorg and runstats in db2?

696


what is diffrence b/w file-aid tool and file-aid utility???

4181


What is the max length of sqlca?

767






How can deadlocks be resolved?

542


What are the prerogatives?

617


Mention the definition of cobol in varchar field.

700


What is load replace in db2?

560


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

751


What is db2 optimizer?

771


Where do you specify them?

681


what is utility for parm lib

1882


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1597


When the like statement is used?

640