Category Archives: SQL

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

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

SQL Commands

SQL commands are instructions used to communicate with the database to perform specific task that work with data. There are 4 types of SQL Commands as follows: Data Definition Language (DDL) – DDL commands are used for creating, modifying, and … Continue reading

Posted in SQL | Leave a comment