Indexes - Relational Database Concepts

profilejvcapm
Home>Homework Answsers>Information Systems homework help

Assume that a student table in a university database has an index on StudentID (the primary key). and additional indexes on Major, Age, Marital status, and HomeZipCode.

Further, assume that the universit wanted a list of students majoring in computer science, over the age of 25, and Married.

How could indexes be used so that only records that satisfy the qualification are accessed?

    • 12 years ago
    • 3
    Report issue
    Answer(0)
    Bids(0)