- Low/Internal level
- Index by one attribute
- For queries selecting by that attribute:
- Faster tuple access (ordered tuples)
- Reduces database memory load
- Small cross product relation, only crosses requisites
- Accelerates query resolution time
- CREATE INDEX Index_Name ON RELATION(Attribute);
In Focus
2.1.25. Indices