Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7211 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehdee
Yes Only one clustering index can be defined.And reason is
Clustered indexe is created to order the rows in the
DB2 table in the same physical order as the desired result
from the indexe. And if we do not use this option, DB2 will
come up with one to do this ordering rows.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What does runstats do in db2?
Explain in brief how does db2 determine what lock-size to use?
How can you quickly find out the # of rows updated after an update statement?
What is the result of open cursor statement?
What is db2 purescale?
What are the various isolation levels possible?
Why db2 is called db2?
What is meant by explain?
How can we retrieve the total number of records in RPG & CLLE?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is null in db2?
What is the meaning concurrency in the db2 database?
What is db2 instance?
Which isolation level provides highest data integrity?
How does db2 sample database connect?
