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.”


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 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.