Next SQL Server Accelerates Complex Queries

The next version of SQL Server, code-named Denali, includes a new option for improving query performance on complex combinations of data. The feature, code-named Apollo, may prove most useful for data warehouses that contain data collected from operations to help track business performance, spot important trends and patterns, and make business decisions. When used with a data warehouse, Apollo provides more rapid reporting and analysis of data while also reducing the amount of preprocessing that IT departments must do to make queries of large data warehouses perform well. This design is intended to simplify data warehouse creation and maintenance and reduce costs. However, Apollo is not ideal for every database.

Apollo Optimized for Rapid Queries

Like other relational databases, SQL Server stores data in tables where each row represents a specific record (such as a sales transaction) and each column represents an attribute of the record (such a customer identifier, product identifiers, and date and time of the transaction). Multiple tables are used to store data related to customers and products as well as more detailed information, in order to minimize the time needed to update the database with each sales transaction.