Deciding Whether to Create an Index
Overview
An index can reduce
the time required to locate a set of rows, especially for a large
data file. However, there are costs associated with creating, storing,
and maintaining the index. When deciding whether to create an index,
you must weigh any benefits in performance improvement against the
costs of increased resource usage.
Note: This chapter discusses the benefits and costs that are
associated with using indexes specifically with PROC SQL. To learn
about the costs and benefits of using indexes with other SAS procedures,
see the SAS documentation.
PROC SQL Queries That Can Be Optimized by an Index
To use indexes effectively with PROC SQL, it is important to know the classes of queries that ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
