What is a clustered index?



What is a clustered index?..

Answer / 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

More DB2 Interview Questions

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,


What are db2 objects?

0 Answers  


What is the difference between db2 and oracle?

0 Answers  


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  


How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  






How to define the data items to receive the fetch items for the SQL?

2 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


How to check last update on table in db2?

0 Answers  


What is EXPLAIN?

1 Answers  


Update command

1 Answers  


How is a typical db2 batch pgm executed?

0 Answers  


Categories