Author Archives: sybaserays

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

Local and global indexes on partitioned tables

Indexes, like tables, can be partitioned. Prior to Adaptive Server 15.0, all indexes were global. With Adaptive Server 15.0, you can create local as well as global indexes. Adaptive Server supports local and global indexes. A local index – spans … Continue reading

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

Partitioning Strategies

Data partitioning breaks up large tables and indexes into smaller pieces that can reside on separate partitions. Note: A segment is a portion of a device that is defined within ASE. It is used for the storage of specific types … Continue reading

Posted in RDBMS concepts | Tagged | Leave a comment

Scrollable Cursors

Adaptive Server Enterprise allows both scrollable and nonscrollable cursors, which can be either semi‐sensitive or insensitive. “Scrollable” means that you can scroll through the cursor result set by fetching any, or many, rows, rather than one row at a time; … Continue reading

Posted in RDBMS concepts | Tagged | Leave a comment

Perl Interview Questions and Answers

Posted in Perl | Tagged | 1 Comment