• Documents
  • Authors
  • Tables
  • Log in
  • Sign up
  • MetaCart
  • Donate

CiteSeerX logo

Advanced Search Include Citations
Advanced Search Include Citations | Disambiguate

Query Optimization (1996)

Cached

Download Links

  • [www.cs.uoi.gr]
  • [infolab.stanford.edu]
  • [infolab.stanford.edu]
  • [www.cs.uoi.gr]
  • [cs.kaist.ac.kr]
  • [www-db.stanford.edu]
  • [cs.kaist.ac.kr]
  • [www.madgik.di.uoa.gr]
  • [medoc.springer.de:9999]
  • [www-2.cs.cmu.edu]

  • Other Repositories/Bibliography

  • DBLP
  • Save to List
  • Add to Collection
  • Correct Errors
  • Monitor Changes
by Yannis E. Ioannidis
Citations:147 - 5 self
  • Summary
  • Citations
  • Active Bibliography
  • Co-citation
  • Clustered Documents
  • Version History

BibTeX

@MISC{Ioannidis96queryoptimization,
    author = {Yannis E. Ioannidis},
    title = {Query Optimization},
    year = {1996}
}

Share

Facebook Twitter Reddit Bibsonomy

OpenURL

 

Abstract

Imagine yourself standing in front of an exquisite buffet filled with numerous delicacies. Your goal is to try them all out, but you need to decide in what order. What exchange of tastes will maximize the overall pleasure of your palate? Although much less pleasurable and subjective, that is the type of problem that query optimizers are called to solve. Given a query, there are many plans that a database management system (DBMS) can follow to process it and produce its answer. All plans are equivalent in terms of their final output but vary in their cost, i.e., the amount of time that they need to run. What is the plan that needs the least amount of time? Such query optimization is absolutely necessary in a DBMS. The cost difference between two alternatives can be enormous. For example, consider the following database schema, which will be...

Keyphrases

query optimization    overall pleasure    numerous delicacy    cost difference    exquisite buffet    following database schema    database management system    query optimizers    final output    many plan   

Powered by: Apache Solr
  • About CiteSeerX
  • Submit and Index Documents
  • Privacy Policy
  • Help
  • Data
  • Source
  • Contact Us

Developed at and hosted by The College of Information Sciences and Technology

© 2007-2016 The Pennsylvania State University