Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7105 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is a SELECT statement?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do you do the EXPLAIN of a dynamic SQL statement?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What are the benefits of using the db2 database?
Which catalog tables contain authorization information?
What is concurrency in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is an intent lock?
What is meant by the attachment facility?
I use CS and update a page. Will the lock be released after I am done with that page?
Which transaction use a command thread ?
COBOL 
