Sciweavers

21 search results - page 1 / 5
» Stacked indexed views in microsoft SQL server
Sort
View
SIGMOD
2005
ACM
89views Database» more  SIGMOD 2005»
13 years 10 months ago
Stacked indexed views in microsoft SQL server
Appropriately selected materialized views (also called indexed views) can speed up query execution by orders of magnitude. Most database systems limit support for materialized vie...
David DeHaan, Per-Åke Larson, Jingren Zhou
SIGMOD
2005
ACM
119views Database» more  SIGMOD 2005»
13 years 10 months ago
Database tuning advisor for microsoft SQL server 2005: demo
Database Tuning Advisor (DTA) is a physical database design tool that is part of Microsoft’s SQL Server 2005 relational database management system. Previously known as “Index ...
Sanjay Agrawal, Surajit Chaudhuri, Lubor Koll&aacu...
VLDB
2004
ACM
169views Database» more  VLDB 2004»
13 years 10 months ago
Database Tuning Advisor for Microsoft SQL Server 2005
The Database Tuning Advisor (DTA) that is part of Microsoft SQL Server 2005 is an automated physical database design tool that significantly advances the state-of-the-art in sever...
Sanjay Agrawal, Surajit Chaudhuri, Lubor Koll&aacu...
VLDB
1997
ACM
124views Database» more  VLDB 1997»
13 years 9 months ago
An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server
In this paper we describe novel techniques that make it possible to build an industrial-strength tool for automating the choice of indexes in the physical design of a SQL database...
Surajit Chaudhuri, Vivek R. Narasayya
VLDB
1999
ACM
107views Database» more  VLDB 1999»
13 years 9 months ago
The Value of Merge-Join and Hash-Join in SQL Server
Microsoft SQL Server was successful for many years for transaction processing and decision support workloads with neither merge join nor hash join, relying entirely on nested loop...
Goetz Graefe