Access Path
“Access path:” a way of retrieving tuples from a relation
- Assuming some selection criterion such as WHERE S.id <= 200
Either:
- A scan of the whole file
- An index which has an appropriate match
- There might be indexes that don’t provide an access path because they don’t relate to the selection criterion