ocr: INDEX INDEX ONLY SORT INDICATOR PREFETCH MATERIALIZATION Any Any No Not. L Incremental Yes No No Hybrid - - RID list - Sort RIDS Any Any Unique Not L Hybrid Sort data Temp table Yes No Unique Hybrid RID list Sort RIDS Sort data Temp table TABLE 3A. Column functions with DISTINCT. INDEX INDEX ONLY SORT INDICATOR PREFEICR MALERIALIZATLUN Any Any No Not L Incremental Yes No No Hybrid - RID list Sort RIDS TABLE 38. Column functions without DISTINCT.
