Is it slower if you access a record through ALT INDEX as
compared to Primary INDEX? Why?
- 1 Answers
- 5551 Views
- I also Faced
- E-Mail Answers
Answer / scott
If you are reading more than one record it is potentially
slower using the ALT INDEX. The reason is the primary index
is clustered, so you do not perform an I/O when you get the
next record in the index.
| Is This Answer Correct ? | 9 Yes | 0 No |
How is the sorting of vsam files carried?
looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?
How many Alternate Indexes you can have on a dataset?
Hi, I want to create alternate index on VSAM file.my file structure is ex: RoomID pic x(7) R000001 Floor pic a((6) First RoomNo pic x(2) FA1 Occupied(yes/no) pic a(3) Yes Occupied Batch pic x(10). Maths i want to create alternate index on floor,roomno fields.can i create alternate index on both the fields.and tell me how to create.
What is a path?
in a cobol select statement, can you tell what is the organization for a ksds?
How to declare the EMP Name, EMP No., DOB in VSAM KSDS file? Please explain.....
There are at least seven IDCAMS commands; name and explain each of them ?.
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
how to view clusters that has more than 10000 records
What's a LDS (Linear Data Set) and what's it used for?
What is the purpose of idcams?
COBOL 
