Example
Query:
SELECT deptno FROM emp WHERE sex = ‘M’
Algorithm:
1. Read SEX index record with value ‘M’;
2. For all RIDs r in RID-set...
3. Read block which holds value for DEPTNO for record r;
4. Decode and output DEPTNO value.
Previous slide
Next slide
Back to first slide
View graphic version