Skip navigation

Assume referential integrity for Hyper Multi Table Extracts

score 12
You have not voted. Active

In 2018.3 we got the ability to store our Hyper extracts in a multiple table format, but we cannot "assume referential integrity" for the data model.


I checked the queries generated and Hyper does indeed join all tables irregardless of whether or not they are needed in the view.


This seems like a small cog one could easily turn to edge out a bit of performance as long as you are aware of the requirements to referential integrity.


Vote history