首页>
外国专利>
METHOD AND SYSTEM FOR IMPROVING SQL DATABASE QUERY PERFORMANCE
METHOD AND SYSTEM FOR IMPROVING SQL DATABASE QUERY PERFORMANCE
展开▼
机译:改善sql数据库查询性能的方法和系统
展开▼
页面导航
摘要
著录项
相似文献
摘要
Methods and systems for rewriting database queries, and in particular databases using Structured Query Language (SQL). The method comprises the steps of reviewing a SQL query statement having a SELECT list to determine if a view definition of the query has one or more unreferenced view columns; and removing at least one of the one or more unreferenced view columns from the view definition. The step of removing at least one of the one or more unreferenced view columns may also include removing all of the one or more unreferenced view columns from the view definition. This method improves performance of a query given that the spool file generated by the query rule contains minimal amount of data necessary for the query to be processed.
展开▼