1. A method of optimizing a database query, the method comprising: analyzing a database query to determine when a predicate structure in the query is a candidate for a symbol table only data structure by analyzing at least one of a query syntax, system generated predicates, and requisite statistics of the database query; analyzing the predicate structure to determine when the predicate structure is already encompassed by an encoded vector index; and generating the symbol table only data structure for at least one column in a database table without generating a corresponding vector data structure from an encoded vector index when the predicate structure is a candidate and not encompassed by an encoded vector index.
1. A method of optimizing a database query, the method comprising: analyzing a database query to determine when a predicate structure in the query is a candidate for a symbol table only data structure by analyzing at least one of a query syntax, system generated predicates, and requisite statistics of the database query; analyzing the predicate structure to determine when the predicate structure is already encompassed by an encoded vector index; and generating the symbol table only data structure for at least one column in a database table without generating a corresponding vector data structure from an encoded vector index when the predicate structure is a candidate and not encompassed by an encoded vector index. 8. The method of claim 1 wherein generating the symbol table only data structure is triggered when needed by a query optimizer.