PDA

View Full Version : Composite key query optimization



barrymavin
2015-03-18, 03:49
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 also use filtered indexes if they match the query.

In v1.4.1 composite keys that may have some functions in them that convert the data type of a column are also taken into consideration.

Here are a few screenshots to show you the sort of performance I'm now seeing on > 1m record tables.

1054

1055

phabio
2015-03-18, 05:38
Great performance!
Great Barry.

ciao
Fabio

HankFay
2015-03-18, 10:05
Good job!