Skip navigation

Assume referential integrity for Hyper Multi Table Extracts

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

Comments

Vote history