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

What is load replace in db2?

666


What r the comman abends in db2, jcl and cobol???????

1941


What do you mean by rollback?

687


What is cobol db2?

671


Name the various locking levels available?

754






What is difference between isnull and coalesce?

725


How do I import a csv file into db2?

673


What do you mean by between and in? Is between inclusive of specified range values?

797


What is the difference between db2 and oracle?

791


What does runstats do in db2?

719


can we view the access paths created by dbrm ? how ? thx

6504


What is scrollable cursor in db2?

726


What is the use of commit in db2?

738


What do you mean by commit and rollback?

716


What is the clustering index in the db2 database?

682