Amazon Aurora DSQL Gets Partial Indexes for Smarter Query Performance
Amazon Aurora DSQL now supports partial indexes, letting you index only a specific subset of rows using a WHERE clause in CREATE INDEX. This keeps your indexes lean and fast, especially useful for tables mixing active working sets with historical data, and it's available across all AWS Regions where Aurora DSQL operates.
source: [aws/whats-new]