Sciweavers

34 search results - page 1 / 7
» Optimization of Nested SQL Queries by Tableau Equivalence
Sort
View
DBPL
1999
Springer
131views Database» more  DBPL 1999»
13 years 9 months ago
Optimization of Nested SQL Queries by Tableau Equivalence
Vasilis Aggelis, Stavros S. Cosmadakis
ICDE
2007
IEEE
117views Database» more  ICDE 2007»
14 years 6 months ago
Unnesting Scalar SQL Queries in the Presence of Disjunction
Optimizing nested queries is an intricate problem. It becomes even harder if in a nested query the linking predicate or the correlation predicate occurs disjunctively. We present ...
Matthias Brantner, Norman May, Guido Moerkotte
BTW
2003
Springer
170views Database» more  BTW 2003»
13 years 10 months ago
Executing Nested Queries
Abstract: Optimization of nested queries, in particular finding equivalent “flattened” queries for queries that employ the SQL sub-query construct, has been researched extensiv...
Goetz Graefe
ICDE
2006
IEEE
213views Database» more  ICDE 2006»
13 years 11 months ago
Optimization of Complex Nested Queries in Relational Databases
Due to the flexible structures of SQL, no general approach works efficiently for all kinds of queries. Some special kinds of queries can be further optimized for better performa...
Bin Cao
VLDB
2005
ACM
122views Database» more  VLDB 2005»
13 years 10 months ago
Optimizing Nested Queries with Parameter Sort Orders
Nested iteration is an important technique for query evaluation. It is the default way of executing nested subqueries in SQL. Although decorrelation often results in cheaper non-n...
Ravindra Guravannavar, H. S. Ramanujam, S. Sudarsh...