Hugo Kornelis continues a series on temporal table performance:
Welcome to part eighteen of the plansplaining series. Like the previous posts, this one too focuses on temporal tables and their effect on the execution plan. After looking at data modifications in temporal tables and at querying with a most basic temporal form of temporal query, let’s look at the more advanced variations for temporal querying.
We’re still looking at getting data from a single query only in this post. We’ll look at joins in the next post.
Click through for these scenarios.