SQL Server code named “Denali” introduces a new data warehouse query acceleration feature based on a new type of index. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases, and can routinely give a tenfold speedup for a broad range of decision support queries. This can allow end users to get more business value from their data through fast, interactive exploration. IT workers can reduce development costs and ETL times since these indexes limit or eliminate the need to rely on pre-built aggregates, including user-defined summary tables and indexed (materialized) views. Hear about the details here first!