I have recently been learning about temporal tables in AzureSQL and am considering implementing this into my codebase. However, columnstore indexes are only available for Azure SQL databases of tier S3 and above. The price of this tier is very high, so I am hesitant. How would temporal tables perform with a rowstore index instead of columnstore? Or is there any alternative tech, or a workaround? Or is the alternative to just create a DIY temporal table using triggers and an active flag on the most recent record?
Hope this makes sense and any feedback or ideas would be great 🙂