21 search results - page 2 / 5 » Stacked indexed views in microsoft SQL server |
SIGMOD
2004
ACM
15 years 9 months ago
2004
ACM
In addition to indexes and materialized views, horizontal and vertical partitioning are important aspects of physical design in a relational database system that significantly imp...
144
click to vote
ICDE
1999
IEEE
15 years 11 months ago
1999
IEEE
Indexes play a vital role in decision support systems by reducing the cost of answering complex queries. A popular methodology for choosing indexes that is adopted by database adm...
79
Voted
ADBIS
2004
Springer
15 years 3 months ago
2004
Springer
In this paper we describe a prototype implementation of updateable views called “SBQL Views”. The prototype follows a novel approach to view updates based on the Stack-Based Ap...
PVLDB
2008
14 years 9 months ago
2008
Immortal DB is a transaction time database system designed to enable high performance for temporal applications. It is built into a commercial database engine, Microsoft SQL Serve...
ICDE
2010
IEEE
15 years 9 months ago
2010
IEEE
Decision support queries that scan large indexes can suffer significant degradation in I/O performance due to index fragmentation. DBAs rely on rules of thumb that use index size a...