I’m interested in temporal tables which are SQL:11 standard, and exist in MS and Oracle.
I’ve seen both:
I haven’t found other resources and in particular I’m curious about the impact of setting the GC configurable date for a versioned table to a long period of time. What’s the impact on performance/space/other?
Does anyone have additional reading for the above topic and/or are there other bits that need to be considered in the CDB world of temporal tables vs something like SQL server? (https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-2017)