Sciweavers

4 search results - page 1 / 1
» An Efficient Cost-Driven Index Selection Tool for Microsoft ...
Sort
View
VLDB
1997
ACM
124views Database» more  VLDB 1997»
13 years 8 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
SIGMOD
1998
ACM
145views Database» more  SIGMOD 1998»
13 years 9 months ago
AutoAdmin 'What-if' Index Analysis Utility
As databases get widely deployed, it becomes increasingly important to reduce the overhead of database administration. An important aspect of data administration that critically i...
Surajit Chaudhuri, Vivek R. Narasayya
ICDE
1999
IEEE
101views Database» more  ICDE 1999»
14 years 6 months ago
Index Merging
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...
Surajit Chaudhuri, Vivek R. Narasayya
ICDE
2010
IEEE
170views Database» more  ICDE 2010»
14 years 4 months ago
Workload Driven Index Defragmentation
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...
Manoj Syamala, Vivek R. Narasayya