An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server

No abstract is available for this paper.

• Publication year

  1997

• Venue

  Very Large Data Bases Conference

• Publication date

  1997-08-25

• Fields of study

  Computer Science

• Identifiers

  No identifiers available.

• External record

  Open on Semantic Scholar

• Source metadata

  Semantic Scholar

• No claims are published for this paper.

• No concepts are published for this paper.

• Physical database design for data warehouses

  1997cited by this paper
• Index selection for OLAP

  1997cited by this paper
• Materialized view maintenance and integrity constraint checking: trading space for time

  1996cited by this paper
• Implementing data cubes efficiently

  1996cited by this paper
• On the automation of physical database design

  1993cited by this paper
• ORACLE Performance Tuning

  1993cited by this paper
• Index selection in relational databases

  1993cited by this paper
• Adaptive and Automated Index Selection in RDBMS

  1992cited by this paper
• Rdb/VMS A Comprehensive Guide

  1991cited by this paper
• A Framework for Automating Physical Database Design

  1991cited by this paper
• Physical database design for relational databases

  1988influential reference
• Index selection in a self-adaptive data base management system

  1976cited by this paper

• Cost Optimization and Performance Engineering in Lakehouses

  2026cites this paper
• Refining storage strategy through index selection methods in multi-model database systems: A survey

  2026cites this paper
• Bespoke OLAP: Synthesizing Workload-Specific One-size-fits-one Database Engines

  2026cites this paper
• Arbiter: Towards joint and fine-grained index and partition tuning in analytical databases

  2026cites this paper
• Towards a Hybrid Quantum-Classical Computing Framework for Database Optimization Problems in Real Time Setup

  2026cites this paper
• UTune: Towards Uncertainty-Aware Online Index Tuning

  2026cites this paper
• Is Quantum Computing Ready for Real-Time Database Optimization?

  2026cites this paper
• Database Optimization for Low-Latency Analytics with Adaptive Indexing

  2026cites this paper
• Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

  2025cites this paper
• Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads

  2025cites this paper
• Esc: An Early-Stopping Checker for Budget-aware Index Tuning

  2025influential citation
• Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis]

  2025cites this paper
• Guiding Index Tuning Exploration with Potential Estimation

  2025influential citation
• AMAZe: A Multi-Agent Zero-shot Index Advisor for Relational Databases

  2025cites this paper
• Efficient Indexing for OLTP Workloads: A Rule-based Approach for PostgreSQL

  2025cites this paper
• LLMIdxAdvis: Resource-Efficient Index Advisor Utilizing Large Language Model

  2025cites this paper
• A New Paradigm in Tuning Learned Indexes: A Reinforcement Learning Enhanced Approach

  2025cites this paper
• AXE: A Task Decomposition Approach to Learned LSM Tuning

  2025cites this paper
• OptimAIzerSQL: Optimizing SQL Queries with Heuristic and ML-Based Multi-Agent Systems

  2025cites this paper
• BISLearner: Block-Aware Index Selection using Attention-Based Reinforcement Learning for Data Analytics

  2025cites this paper
• Hyper: Hybrid Physical Design Advisor with Multi-agent Reinforcement Learning

  2025cites this paper
• L2T-Tune:LLM-Guided Hybrid Database Tuning with LHS and TD3

  2025cites this paper
• Deep Reinforcement Learning for Autonomous Cost and Performance Optimization of Big Data Query Engines in the Cloud

  2025cites this paper
• E2RLIXT: An end-to-end framework for robust index tuning based on reinforcement learning

  2025cites this paper
• AskDB: An LLM Agent for Natural Language Interaction with Relational Databases

  2025cites this paper
• Index Selection in Database Based on Query Arrival Rate Prediction

  2025cites this paper
• Towards a Periodic Table of Computer System Design Principles

  2025cites this paper
• Benchmarking SQL Query Optimization Techniques Across Major RDBMS PlatformsBenchmarking SQL Query Optimization Techniques Across Major RDBMS Platforms

  2025cites this paper
• Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees

  2025cites this paper
• MAAdvisor: Zero-Shot Index Advisor using Multi-Agent LLMs

  2025cites this paper
• Twisted Twin: A Collaborative and Competitive Memory Management Approach in HTAP Systems

  2025cites this paper
• Selective Use of Yannakakis' Algorithm to Improve Query Performance: Machine Learning to the Rescue

  2025cites this paper
• MINT: Multi-Vector Search Index Tuning

  2025cites this paper
• DEPA-Delta Shifting and Distribution Shaping for Efficient Adaptive Indexing

  2025cites this paper
• AutoIndexer: A Reinforcement Learning-Enhanced Index Advisor Towards Scaling Workloads

  2025cites this paper
• SQL:Trek Automated Index Design at Airbnb

  2025cites this paper
• Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning

  2024influential citation
• Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches

  2024cites this paper
• IA2: Leveraging Instance-Aware Index Advisor with Reinforcement Learning for Diverse Workloads

  2024cites this paper
• PilotScope: Steering Databases with Machine Learning Drivers

  2024cites this paper
• Robustness of Updatable Learning-based Index Advisors against Poisoning Attack

  2024cites this paper
• Wred: Workload Reduction for Scalable Index Tuning

  2024cites this paper
• Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless

  2024cites this paper
• Leveraging Dynamic and Heterogeneous Workload Knowledge to Boost the Performance of Index Advisors

  2024cites this paper
• Can Uncertainty Quantification Improve Learned Index Benefit Estimation?

  2024cites this paper
• Breaking It Down: An In-depth Study of Index Advisors

  2024cites this paper
• TRAP: Tailored Robustness Assessment for Index Advisors via Adversarial Perturbation

  2024influential citation
• ACDRL: A constraint-guided dynamic reinforcement learning for index selection

  2024cites this paper
• Wii: Dynamic Budget Reallocation In Index Tuning

  2024cites this paper
• Eraser: Eliminating Performance Regression on Learned Query Optimizer

  2024cites this paper
• MFIX: An Efficient and Reliable Index Advisor via Multi-Fidelity Bayesian Optimization

  2024cites this paper
• Lero: A Learning-to-Rank Query Optimizer

  2023cites this paper
• A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning

  2023cites this paper
• Survey on performance optimization for database systems

  2023cites this paper
• D-Bot: Database Diagnosis System using Large Language Models

  2023cites this paper
• Data-centric Artificial Intelligence: A Survey

  2023cites this paper
• DBAugur: An Adversarial-based Trend Forecasting System for Diversified Workloads

  2023cites this paper
• Stitcher: Learned Workload Synthesis from Historical Performance Footprints

  2023cites this paper
• Automatic Database Knob Tuning: A Survey

  2023cites this paper
• Towards flexibility and robustness of LSM trees

  2023cites this paper
• Indexation techniques in decision support systems: Study and Evaluation

  2023cites this paper
• LLM As DBA

  2023cites this paper
• ML-Powered Index Tuning: An Overview of Recent Progress and Open Challenges

  2023influential citation
• A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies

  2023cites this paper
• Utilizing deep learning for automated tuning of database management systems

  2023cites this paper
• Active Sampling for Sparse Table by Bayesian Optimization with Adaptive Resolution

  2023cites this paper
• Hybrid Index Selection Using Integer Linear Programming Based on Cached Cost Estimates of Heuristic Approaches

  2023influential citation
• Demonstration of ViTA: Visualizing, Testing and Analyzing Index Advisors

  2023cites this paper
• Pando: Enhanced Data Skipping with Logical Data Partitioning

  2023cites this paper
• AIM: A practical approach to automated index management for SQL databases

  2023cites this paper
• HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning

  2022cites this paper
• Robust Index Selection for Stochastic Dynamic Workloads

  2022influential citation
• ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning

  2022cites this paper
• Machine Learning for Computer Systems and Networking: A Survey

  2022cites this paper
• SWIRL: Selection of Workload-aware Indexes using Reinforcement Learning

  2022cites this paper
• AutoIndex: An Incremental Index Management System for Dynamic Workloads

  2022influential citation
• Are Updatable Learned Indexes Ready?

  2022cites this paper
• Budget-aware Index Tuning with Reinforcement Learning

  2022influential citation
• ESDB: Processing Extremely Skewed Workloads in Real-time

  2022cites this paper
• Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities

  2022cites this paper
• Solver-based Approaches for Robust Multi-index Selection Problems with Stochastic Workloads and Reconfiguration Costs

  2022influential citation
• DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning

  2022influential citation
• External vs. Internal: An Essay on Machine Learning Agents for Autonomous Database Management Systems

  2022cites this paper
• Database parallelism, big data and analytics, deep learning

  2022cites this paper
• LightPro: Lightweight Probabilistic Workload Prediction Framework for Database-as-a-Service

  2022cites this paper
• Indexer++: workload-aware online index tuning with transformers and reinforcement learning

  2022cites this paper
• HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements

  2022influential citation
• Implementation and Selection of Derived Partitioning for Optimizing the Performances of Relational Data Warehouses

  2021cites this paper
• Novel approaches on bulk‐loading of large scale spatial datasets

  2021cites this paper
• Hyperspace: The Indexing Subsystem of Azure Synapse

  2021cites this paper
• Towards instance-optimized data systems

  2021cites this paper
• The index selection problem with configurations and memory limitation: A scatter search approach

  2021cites this paper
• One Model to Rule them All: Towards Zero-Shot Learning for Databases

  2021cites this paper
• Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty

  2021cites this paper
• CPRQ: Cost Prediction for Range Queries in Moving Object Databases

  2021cites this paper
• Replicated Layout for In-Memory Database Systems

  2021cites this paper
• Deep Learning Data and Indexes in a Database

  2021influential citation
• Experience-Enhanced Learning: One Size Still does not Fit All in Automatic Database

  2021cites this paper
• Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation

  2021cites this paper
• FasTensor Programming Model

  2021cites this paper