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 dbrm in db2 database?

591


Can we update view in db2?

562


What is the syntax for creating a table in the db2 database?

628


What is rebind in db2?

576


What is precompiler in db2?

587






What is a dbrm in db2?

576


What is a db2 package?

599


Give the name of some fields form sqlca.

611


What os does db2 run on?

572


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

1820


What is the use of runstats in db2?

577


What is cursor in dbms?

592


What is the use of db2?

586


Are view updateable?

628


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7512