Category Archives: Sybase ASE

Derived tables

A derived table is defined by the evaluation of a query expression and differs from a regular table in that it is neither described in system catalogs nor stored on disk. In Adaptive Server, a derived table may be a … Continue reading

Posted in RDBMS concepts, Sybase ASE | Tagged | Leave a comment

Computed columns

Computed columns were introduced in Sybase ASE 15 to provide easier data manipulation and faster data access. Computed columns are columns that are defined by an expression. This expression can be built by combining regular columns in the same row … Continue reading

Posted in RDBMS concepts, SQL, Sybase ASE | Tagged , , , | 2 Comments

Logged operations

When you create and populate temporary tables in tempdb, use the select into command, rather than create table and insert…select, whenever possible. The select into/bulkcopy database option is turned on by default in tempdb to enable this behavior. select into operations … Continue reading

Posted in Sybase ASE | Tagged | Leave a comment

Identity column

An IDENTITY column contains a value for each row, generated automatically by Adaptive Server, that uniquely identifies the row within the table. Each table can have only one IDENTITY column. You can define an IDENTITY column when you create a … Continue reading

Posted in Identity column, RDBMS concepts, Sybase ASE | Tagged , , | Leave a comment

Temporary Tables

In this section we will discuss about Temporary tables in Sybase ASE. I found temporary tables are very useful, many times in my work experience. From name itself you can guess that Temporary table is temporary but not permanent in … Continue reading

Posted in Sybase ASE | Tagged , , | Leave a comment

Query Processor

Query processor processes SQL queries specified by user. The processor yields highly efficient query plans that execute using minimal resources, and ensure that results are consistent and correct. To process a query efficiently, the query processor uses: SQL Query specified by user. … Continue reading

Posted in Query Processing, SQL, Sybase ASE | 1 Comment