SPD Server includes
SQL Planner optimizations. SQL Planner optimizations improve the performance
of the more frequent query types that used in data mining solutions
such as Enterprise Marketing Automation. A key enhancement to the
SPD Server SQL Planner is optimizing correlated queries through the
use of query rewrite techniques. Correlated queries are common in
business and analytic intelligence data mining. Another significant
enhancement is the tighter integration of the Parallel Group-By technology
in the planner. The tighter integration adds performance benefits
to nested Group-By syntax.