Chapter 8Functional Indexes

This chapter focuses on computed column indexes and function-based indexes. These features are an extension to the existing create index command. Examples of code are provided to show how the functionality of each feature can be best utilized. Particular attention is paid to the following areas:

Limitations of the current implementation of each feature in ASE 15

Positive and negative impacts to tempdb for each feature

Get The Official New Features Guide to Sybase ASE 15 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.