ocr: INDEX INDEX ONLY SORT INDICATOR PREFETCH MATERIALIZATION Any Any No Not L Incremental Yes No No L Hybrid RID list Sort RIDS Any Any Unique Not L Full Sort data Temp table Yes No Unique Full RID list Sort RIDS Sort data Temp table Notes 1. "Any" means that it does not matter what value: is in that position. 2. Sometimes. we: have combined method 3 EXPLAIN output lines indicating a sort of the com- posite table together with the line explaining the access to the table. TABLE 2. SELECT DISTINCT.
