METHOD AND QUERY OPTIMIZATION SERVER FOR ASSOCIATING FUNCTIONS WITH COLUMNS FOR OPTIMIZING QUERY EXECUTION

摘要

A method of optimizing query execution by associating functions with columns includes receiving, by a query optimization server, data definition statement including information of one or more columns and function information for each of the one or more columns. The query optimization server associates the columns having the function information with corresponding predefined functions and stores in a memory. Upon receiving a query comprising a function associated to a column, the query optimization server compares the function with predefined functions stored in the memory. The query optimization server accesses the predefined function from the memory for executing the query based on the comparison.