How many clustering indexes can be defined for a table?
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 |
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
what is REORG? what is the use?
What does db2 mean?
how do u update the faltfile into db2 table ?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
Do we need cursor for Count(*)?
How do I import a csv file into db2?
How does DB2 store NULL physically?
what are bind concepts in db2 cobol?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Where are plans stored?