I've been doing some work on the SQL query optimizer quietly in every release of the product.

The optimizer already handles partial key index restriction and composite keys. The optimizer will...