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

Comment whether the cursor is closed during commit or not.

899


Why cursor is used in db2?

800


What is precompiler in db2?

811


How to view db2 table structure?

825


What is dbrm in db2 database?

832


If I have a view which is a join of two or more tables, can this view be updateable?

939


Is db2 a database?

772


What does db2 stand for?

799


What is cascading rollback?

887


How to connect to db2 database from windows command line?

828


How can record locking be achieved in those DB2 versions which do not support it?

864


What action db2 takes when a program aborts in the middle of a transaction?

907


Which are the db2 tools to protect integrity of the database?

934


What is ibm db2 used for?

853


What is the use of db2 optimizer?

859