Partial indexes allow database users to define indexes over rows meeting specific conditions via a WHERE clause, focusing on active working sets rather than entire tables. This approach benefits scenarios where large tables contain small subsets of frequently accessed data, such as open orders compared to historical data.
By indexing only relevant rows, partial indexes reduce index size and speed up queries targeting these subsets. Aurora DSQL automatically leverages these indexes for queries matching the partial index conditions. This feature is available in all AWS Regions supporting Aurora DSQL.
Source & further reading
Amazon Aurora DSQL now supports partial indexes ↗Source published 2026-10-02. This report was prepared with AI assistance from the linked primary-source material. Claims and limitations should be checked against the original announcement or research.