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 the role of the cursor in db2?

813


What is reorg?

836


What is cursor with hold option in db2?

804


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 .....

2104


Explain correlated sub-queries.

768


What is syscat in db2?

772


What is the purpose of rollback and commit?

798


can all users have the privilage to use the sql statement select * (dml)?

841


What is a db2 tablespace?

782


What is a page in db2?

795


What is bufferpool in db2?

802


What is nvl in db2?

816


What is iseries database?

779


How many databases are there?

774


What is dbrm in db2 database?

786