3 ms·
Columnstore and B+ tree – are hybrid physical designs important?
- ddorian43 8y agoSame thing do real-time search-engine. They store checkpointed-data in inverted-index type, and real-time data in b+tree.
- striking 8y ago> DTA uses a cost-base search, which means it needs to estimate the costs using some indexes it hasn’t actually built yet. The “what-if” API is used to simulate such hypothetical indexes. Reminds me of https://github.com/ankane/dexter https://github.com/ankane/dexter with https://github.com/HypoPG/hypopg https://github.com/HypoPG/hypopg.