What is a clustering index ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1985


What is db2 purescale?

766


Explain what are the various isolation levels possible?

815


How will you return the number of records in table?

716


How is deadlock resolved?

846


Is schema the same as database?

841


Is ibm db2 open source?

830


What is buffer pool in the db2 database?

851


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

850


How to create backup table in db2?

861


How do I copy a table in db2?

765


What is the use of value function?

852


What is reorg and runstats in db2?

958


What is coalesce in db2?

873


How do I optimize a query in db2?

834