Amazon Aurora DSQL now supports partial indexes

Amazon Aurora DSQL

Amazon Aurora DSQL now allows you to build an index over a specific subset of a table, storing only qualifying rows rather than every row in the entire table. This improves query performance and lowers index storage cost.

Many tables hold a small working set alongside a much larger history, such as open orders among years of completed ones. You can add a WHERE clause to CREATE INDEX to index just that working set. The index stays small as the table grows, and queries that target those rows read less data. Aurora DSQL uses a partial index for any query whose filter falls within the index's condition.

Partial indexes are available in all AWS Regions where Aurora DSQL is available. To learn more, see CREATE INDEX in the Aurora DSQL User Guide.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.