21 search results - page 2 / 5 » Stacked indexed views in microsoft SQL server |
SIGMOD
2004
ACM
14 years 5 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...
ICDE
1999
IEEE
14 years 6 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...
ADBIS
2004
Springer
13 years 11 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
13 years 5 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
14 years 5 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...