Scan Performance

  • Hasso Plattner


In this chapter, we discuss the performance of the scan operation. Scan operations search one or more attributes for a certain value. Unless the table is sorted by the attribute to scan, a scan has to iterate over all entries and returns those entries, which fulfill the search predicate (e.g. “SELECT * FROM world_population WHERE lastname = “Smith”).

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Hasso Plattner
    • 1
  1. 1.Enterprise Platform and Integration ConceptsHasso Plattner InstitutePotsdamGermany

Personalised recommendations