O'Reilly logo

The Official New Features Guide to Sybase ASE 15 by Carrie King Taylor, Steve Bradley, Naresh Adurty, Brian Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required