The Dynamic Query Mode delivered with IBM Cognos 10.
The Dynamic Query Mode is an enhanced Java based query mode which offers the following key capabilities.
* Query optimizations to address query complexity, data volumes and timeliness expectations with improved query execution techniques. * Significant improvement for complex OLAP queries through intelligent combination of local and remote processing and better MDX generation. * Security-aware caching. * New data Interfaces leveraging 64 bit processing. * Ease of maintenance with query visualization.
the complete document can be found here: