Andreij,

Crystal will simply pass on your SQL request to SQL Server. It has no in-built optimization process. There could be any number of reasons.

Perhaps you should be looking at;

1. Are...