>Every primary key (PK) and foreign key (FK) is indexed. I am getting zero Rushmore optimization.
Set ("Optimize") ? <bg>
I'ld recommend building the joins first to make sure to get best possible rushmore, then add the frill fields. Check if intermediate results need indices, if so split the select.
If the first inner join is huge, you should think of preprocessing some items like
lcNinerFormat = REPLICATE( '9' , m.nNines )
and perhaps minimize the accessing work for the
<<This.aDates[1,2]>>
. But this would probably only be small icing on the cake.
rgds
thomas