The databases and methods disclosed herein reduce costly dictionary access (writes and reads) by storing data directly in an index (e.g., storing literal values or taking advantage of Universally Unique Identifiers (UUIDs)), thereby saving time and memory. One example embodiment is a database that includes a dictionary and an index. The dictionary stores associations between keys and data. Each entry in the index includes a plurality of values corresponding to data. A value of the index includes either (i) a direct representation of corresponding data for certain data types, or (ii) a hash of the corresponding data for other data types. The hash is used in the dictionary as a key associated with the corresponding data.