SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition

Chapter 6Creating and Managing Indexes Using PROC SQL

Overview

Introduction

Objectives

Prerequisites

Understanding Indexes

Accessing Rows in a Table

Simple and Composite Indexes

Unique Indexes

Example

Deciding Whether to Create an Index

Overview

PROC SQL Queries That Can Be Optimized by an Index

Benefits of Using an Index

Example: Using an Index to Access a Small Subset of Data

Understanding the Costs of Using an Index

Guidelines for Creating Indexes

Creating an Index

Overview

Creating Multiple Indexes

Example: Creating a Simple Index

Example: Creating a Composite, Unique Index

Displaying Index Specifications

Overview

Example

Alternatives to the DESCRIBE TABLE Statement

Managing Index Usage

Overview

Understanding How SAS Decides Whether to Use ...