index_selection_evaluation icon indicating copy to clipboard operation
index_selection_evaluation copied to clipboard

Platform to evaluate index selection algorithms

Results 8 index_selection_evaluation issues
Sort by recently updated
recently updated
newest added

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...