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.

 

28 Oct 2017
Answer :
Word Count : 114

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

________ _______ ____ _________ _______ _____ _____ _______ ______ _________ _______ ___.
___ ___ ______ ______ _______ _________.
________ _________ __________ __________ ___ _____.
_________ ________ ___ ________ ________ __________ _________ _________.
____ ___ _____ _____ _______.
_________ ________ _________ _______ ____ _________ ______ __________ ____ ____ _______ _______.
___ ____ _________ ____ ____ _____ ___ ____.
_________ _____ _________ ________ _________ ______ ______ ______ _________ ________ ________ _______.
_____ __________ _________ ________ ____ ___ _____ _____.
_____ ______ ________ ___ _________ _____ ________ ___.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MCS 23 2010 2011 -  Consider a relation student(ID: 9 characters) having about 1 | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→