Can I read Extreme Visualisation of Query Optimizer Search Space on EtoBox?

Extreme Visualisation of Query Optimizer Search Space by Anisoara Nica; Daniel Scott Brotherston; David William Hillis is a scholarly article available to read on EtoBox.

What is Extreme Visualisation of Query Optimizer Search Space about?

This demonstration showcases a system for visualizing and analyzing search spaces generated by the sql Anywhere optimizer during the optimization process of a sql statement. sql Anywhere dynamically optimizes each statement every time it is executed. The decisions made by the optimizer during the optimization process are both cost-based and heuristics adapted to the current state of the server and the database instance. Many performance issues can be understood and resolved by analyzing the search space generated when optimizing a certain request. In our experience, there are two main classes of performance issues related to the decisions made by a query optimizer: (1) a request is very slow due to a suboptimal access plan; and (2) a request has a different, less optimal access plan than a previous execution. We have enhanced sql Anywhere to log, in a very compact format, its search space during the optimization process when tracing mode is on. These search space logs can be used for performance analysis in the absence of the database instances or of extra information about the sql Anywhere server state at the time the logs were generated. This demonstration introduces the SearchSp

Author

Anisoara Nica; Daniel Scott Brotherston; David William Hillis

Publisher

ACM

Published

2009

Language

EN