Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Chapter 2: Database Design and Denormalizing for Performance [Table of Contents] Chapter 4: How Indexes Work

Performance and Tuning Guide

[-] Chapter 3: Data Storage

Chapter 3

Data Storage

This chapter explains how Adaptive Server stores data rows on pages and how those pages are used in select and data modification statements, when there are no indexes. It lays the foundation for understanding how to improve Adaptive Server's performance by creating indexes, tuning your queries, and addressing object storage issues.

This chapter contains the following sections:

[+] Major Performance Gains Through Query Optimization
[+] Adaptive Server Pages
[+] Pages That Manage Space Allocation
[+] Heaps of Data: Tables Without Clustered Indexes
[+] How Adaptive Server Performs I/O for Heap Operations
[+] Caches and Object Bindings
Asynchronous Prefetch and I/O on Heap Tables
Heaps: Pros and Cons
[+] Maintaining Heaps
The Transaction Log: A Special Heap Table

Chapter 2: Database Design and Denormalizing for Performance [Table of Contents] Major Performance Gains Through Query Optimization