32 search results - page 1 / 7 » Techniques for Identifying and Optimizing Resource-Intensive... |
CMG
2007
13 years 6 months ago
2007
DEBU
2008
13 years 5 months ago
2008
Query optimization is an inherently complex problem, and validating the correctness and effectiveness of a query optimizer can be a task of comparable complexity. The overall proc...
ICDE
2000
IEEE
14 years 6 months ago
2000
IEEE
Statistics play a key role in influencing the quality of plans chosen by a database query optimizer. In this paper, we identify the statistics that are essential for an optimizer....
VLDB
1997
ACM
13 years 9 months ago
1997
ACM
In this paper we describe novel techniques that make it possible to build an industrial-strength tool for automating the choice of indexes in the physical design of a SQL database...
SIGMOD
2007
ACM
14 years 5 months ago
2007
ACM
Optimizing SQL subqueries has been an active area in database research and the database industry throughout the last decades. Previous work has already identified some approaches ...