Complex SQL Queries | Sciweavers

46

PVLDB
2008

121views more PVLDB 2008»

QueryScope: visualizing queries for repeatable database tuning

13 years 11 months ago

Reading and perceiving complex SQL queries has been a time consuming task in traditional database applications for decades. When it comes to decision support systems with automati...

Ling Hu, Kenneth A. Ross, Yuan-Chi Chang, Christia...

claim paper

Read More »

35

click to vote

ICDE
2006
IEEE

213views Database» more ICDE 2006»

Optimization of Complex Nested Queries in Relational Databases

14 years 5 months ago

Download ir.iit.edu

Due to the ﬂexible structures of SQL, no general approach works efﬁciently for all kinds of queries. Some special kinds of queries can be further optimized for better performa...

Bin Cao

claim paper

Read More »

90

click to vote

ICDE
2007
IEEE

107views Database» more ICDE 2007»

Robust Heuristics for Scalable Optimization of Complex SQL Queries

15 years 25 days ago

Download dsl.serc.iisc.ernet.in

Gopal Chandra Das, Jayant R. Haritsa

claim paper