Fighting Redundancy in SQL

Abstract. Many SQL queries with aggregated subqueries exhibit redundancy (overlap in FROM and WHERE clauses). We propose a method, called the for-loop, to optimize such queries by ensuring that redundant computations are done only once. We specify a procedure to build a query plan implementing our method, give an example of its use and argue that it offers performance advantages over traditional approaches.

• Type: Conference
• Year: 2003
• Where: DAWAK
• Authors: Antonio Badia, Dev Anand
• Keywords: Data Mining, DAWAK 2003, Many SQL Queries, Redundant Computations, Subqueries Exhibit Redundancy