Advertisement

Optimizing Table Performance

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

Abstract

This chapter details database features that impact the performance of storing and retrieving data within a table. Table performance is partially determined by database characteristics implemented prior to creating tables. For example, the physical storage features implemented when first creating a database and associated tablespaces subsequently influence the performance of tables. Similarly, performance is also impacted by your choice of initial physical features such as table types and data types. Therefore implementing practical database, tablespace, and table creation standards (with performance in mind) forms the foundation for optimizing data availability and scalability

Keywords

Sample Output Business Rule Table Type Delete Statement Basic Compression 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati, Darl Kuhn, and Bill Padfield 2011

Authors and Affiliations

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

There are no affiliations available

Personalised recommendations