I got an anomaly concerning time execution with a query. Take this query :
SELECT TOP 1 * FROM t2 LEFT JOIN t1 ON t1.t1_id = t2.t1_id WHERE t1.t1_id IS NULL
It took 42 minutes.
t1 : 47351 records, only one column and no primary key
t2 : 162825 records, two columns and a composed primary key with the 2 columns (the primary key on two columns seems the problem)
On Access the query took 0,3s.
A test database can be downloaded here :
Note : I simplified the query and the database. With our database it took a lot longer and it's reading more than 2 Terabytes !
2016-09-04 fixed a speed bug on LEFT JOIN when left table has a component index expression.