11 / 577
11
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
Indexing the data
•
Returning the result of a query for a large dataset can take
a considerable time.
•
Introducing indices is an option to counteract this trend.
•
Definition: A data structure improving the search
performance of a database.
•
It stores the values of the indexed column and a pointer to
the row which it is contained in.
•
The cost of faster searches are a slower write performance
and higher disk space consumption.
Think of an index
as the index of a
book with
pointers to the
topics of interest.