What is a clustering index ?

Answer Posted / s

Clustering index determines where the row will be inserted.

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 a bind in db2?

713


What is db2 optimizer?

906


what are bind concepts in db2 cobol?

764


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11247


What is package in db2 mainframe?

673






Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7192


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2014


Which components manage deadlocks in db2?

733


What is the difference between bind and rebind in db2?

1075


What does db2 plan contain?

685


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1767


What is the role of schema in the db2 database?

810


Is schema the same as database?

752


What is db2 purescale?

698


How to compare data between two tables in db2?

775