Question
Consider a relation student(ID: 9 characters) having about 1,000,000 students records. The database is stored on a disk having a disk block size of 1 MB. Assume that the primary index of the relation is ID and its relation is required mostly for the application that generates programme wise list of student names in alphabetical order. Create a secondary index that will improve the performance of the system for the given application. Show how many block transfers will saved on average due to creation of index. Make suitable assumptions if any.
Answer :
Word Count : 114
__________ ________ _________ ________ ___ __________ ___ _________ ______ ________.
_______ ____ __________ _______ __________ _________ ______ ___ _______ _______ __________.
_________ ____ ______ __________ _____.
____ ____ ______ ___ ________ _______ _______ _________ _________ _____ _______ ________.
_____ _______ __________ _______ _______ ____ _____ ________ _______ ____.
__________ ______ _________ ______ ______ _____ _________ _____ ________ ________ __________ ___.
___ ____ ____ __________ ____ ________ ______ _______ _______ _________ ________.
______ ___ ___ ________ __________ _______ _______ ________.
_____ _____ _____ ______ _________.
Skip in 10
PRIMERY INDEX : Primary Index is an ordered files whose records are fixed length with two fields. The first field is of the same data type as the ordering key
_______ ____ __________ _______ __________ _________ ______ ___ _______ _______ __________.
_________ ____ ______ __________ _____.
____ ____ ______ ___ ________ _______ _______ _________ _________ _____ _______ ________.
_____ _______ __________ _______ _______ ____ _____ ________ _______ ____.
__________ ______ _________ ______ ______ _____ _________ _____ ________ ________ __________ ___.
___ ____ ____ __________ ____ ________ ______ _______ _______ _________ ________.
______ ___ ___ ________ __________ _______ _______ ________.
_____ _____ _____ ______ _________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.