How many clustering indexes can be defined for a table?
- 2 Answers
- 6396 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 deadlock in db2?
What is the syntax of SELECT statement when embedded in a COBOL program?
what is difference between random and sequence file access
What is cursor?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is alias in db2?
Can we update view in db2?
how can u retrieve the data from null values using applicaion program.
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is a cursor and what is its function?
Can I use LOCK TABLE on a view?
COBOL 
