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 |
Can AMS commands be run from the TSO prompt ?
By looking into JCL can we identify the dataset is VSAM (VSAM dataset supposed to be a input dataset).In this scenerio how will we identify the dataset is VSAM ?
5 Answers Cognizant, EDS, Shridhar,
What makes vrrds different from vsam?
What is the difference between lds and esds?
what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
What is the purpose of the FILE STATUS clause in the SELECT statement?
What are the advantages of vsam over isam?
what is the use of reuse in vsam?
While designing vsam files,what is the best way to choose control interval size for the data and the index?
What is the main function of key sequenced data set in vsam?
How are different versions of GDG named ?
On which datasets You can have ALT INDEX?