Chapter 7Computed Columns

Computed columns were introduced in Sybase ASE 15 to provide easier data manipulation and faster data access. This chapter gives an overview of computed columns, explains materialization and deterministic properties, and explores their impact on computed columns. This chapter also discusses the benefits of computed columns.

Some of the ASE system stored procedures and tables were enhanced to support computed columns. These changes are listed at the end of the chapter.

The indexes for computed columns are discussed in Chapter 8, “Functional Indexes.”

Introduction

Computed columns are columns that are defined by an expression. This expression can be built by combining regular columns in the same row and may contain functions, ...

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.