A Dramatic new Data Warehouse Query Performance Enhancement in SQL Server “Denali”
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!
Susan Price is a Program Manager in the SQL Server Database Engine. Her current passion is improving query performance for data warehousing.
Register Now for PASS Summit 2010!