Oracle Corporation
ROWID DECODING: AN ALTERNATIVE TO DICTIONARY DECODING

Abstract:

Techniques described herein propose a new RIDDecode operator in a QEP that uses ROWID lookup and fetch, instead of dictionary decoding, to retrieve decoded values, in order to reduce memory pressure and speed up processing.