Skip to content
This repository has been archived by the owner on Jun 14, 2024. It is now read-only.

Scoring applicable indexes #444

Open
sezruby opened this issue May 19, 2021 · 0 comments
Open

Scoring applicable indexes #444

sezruby opened this issue May 19, 2021 · 0 comments
Labels
untriaged This is the default tag for a newly created issue

Comments

@sezruby
Copy link
Collaborator

sezruby commented May 19, 2021

ApplyHyperspace (#405) rule refactoring introduces a scoring function for each index application so that we could rank and select an index with higher performance benefit, if there are more than one applicable index.
With an initial version, it's implemented with simple scoring functions, but we will enhance it later.

JoinIndexRule - CoveringIndex

  • for left child: 70 * (common bytes / source relation bytes)
    • (common bytes / source relation bytes) to consider Hybrid Scan overhead
  • for right child: 70 * (common bytes / source relation bytes)
  • Should be prior than FilterIndexRule - CoveringIndex

FilterIndexRule - CoveringIndex

  • 50 * (common bytes / source relation bytes)
    • (common bytes / source relation bytes) to consider Hybrid Scan overhead
@sezruby sezruby added the untriaged This is the default tag for a newly created issue label May 19, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
untriaged This is the default tag for a newly created issue
Projects
None yet
Development

No branches or pull requests

1 participant