For a DSS/DW application, it is better to use CHOOSE. Also, I found HASH JOIN is far better than Nested Loop. If the system has a lot of memory, enable HASH JOIN and allocate atleast 100 MB for HASH AREA SIZE. Also tune the SQL to use HASH join.

For a Crystal Report, CHOOSE is the best option followed analyzing the schema.