index_selection_evaluation
index_selection_evaluation copied to clipboard
Platform to evaluate index selection algorithms
Hello, thank you for sharing the code! INUM refers to this paper: Efficient Use of the Query Optimizer for Automated Physical Design. CoPhy divides costs into internal sub plan costs...
This PR makes the following changes: - Add frequency parameter to queries. Without specifically changing anything this does not have any effects because the frequency is set to `1` be...
See also comment in `_generate_job()` in `selection/query_generator.py`.
Currently, complete support for Microsoft server is missing even though it seems to be almost done. There is mainly an issue with hypothetical indexes not properly picked up for TPC-H...
A test should verify that the benchmark queries are correct. This could maybe achieved by checking if results are returned or comparing to a fixed validation result set.
I am not fully convinced by the architecture/indirection that the CostEvaluation uses WhatIfIndexCreation uses DBConnector. But this has maybe not a high priority. Besides, I see the danger that CostEvaluation...