Loading...
Please wait, while we are loading the content...
Similar Documents
User-Optimizer Communication using Abstract Plans in Sybase ASE
| Content Provider | CiteSeerX |
|---|---|
| Author | Andrei, Mihnea |
| Abstract | Query optimizers are error prone, due to both their nature and the increased search space that modern query processing requires them to manage. This paper introduces the Sybase Plan (AP) language, a novel technology that puts together a set of proven techniques to palliate optimizer mistaken decisions. The AP language is a 2-way user-optimizer communication mechanism based on a physical level relational algebra. AP expressions are used both by the optimizer to describe the plan that it selected and by the user to direct the optimizer choices. APs are not textually part of the query. They are persistent objects stored in the system catalogs. APs yield important performance gains by eliminating all optimizer errors. 1. |
| File Format | |
| Access Restriction | Open |
| Subject Keyword | Important Performance Gain Ap Language 2-way User-optimizer Communication Mechanism Ap Expression User-optimizer Communication Proven Technique Optimizer Error Modern Query Processing Query Optimizers Physical Level Relational Algebra Novel Technology Optimizer Choice Persistent Object Search Space System Catalog Sybase Ase Sybase Plan Optimizer Mistaken Decision Error Prone Abstract Plan |
| Content Type | Text |
| Resource Type | Article |
