How many Alternate Indexes you can have on a dataset?
Answers were Sorted based on User's Feedback
Answer / sivakumar devaram
253.but not more than 5 recommended because of overheada in
storing and maintaining alternate indexes.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / guest
255 - but you must be a nut to have so many ALT Indexes on a
dataset!
| Is This Answer Correct ? | 7 Yes | 6 No |
What are the common vsam error conditions and codes?
What is a vsam dataset?
If you wish to use the REWRITE command haw must the VSAM file be opened?
explain the information contained in ci
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
explain how do you define a gdg in vsam?
What makes vrrds different from vsam?
While designing vsam files,what is the best way to choose control interval size for the data and the index?
What is control area?
difference between vsam and database tables
What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?
On which dataset you can have alt index?