Assume referential integrity for Hyper Multi Table Extracts
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.
Comments