首页>
外国专利>
Method and Query Optimization Server for Associating Functions with Columns for Optimizing Query Execution
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.
展开▼