Monthly Archives: June 2013

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