Tag: partitioning

Archive Read-Only Data from RDS SQL Server to Partitioned S3 Buckets

Overview Here’s a scenario we’ve seen in many businesses; your SQL Server database has grown to the point that performance has degraded significantly, and your business no longer meets the intended RTO (recovery time objective). In this case, your database…

Read More >

Oracle parallel query hints reference – part 6: USE_PARTITION_WISE_GBY

Welcome to part 6 of the series. The USE_PARTITION_WISE_GBY hint is “brand new,” introduced in 12.2. I personally welcome this hint as I’ve cursed many times in the past due to the lack of control for this aspect of parallelism…

Read More >