Expert Oracle indexing and access paths : maximum performance for your database /: maximum performance for your database. (2016)
- Record Type:
- Book
- Title:
- Expert Oracle indexing and access paths : maximum performance for your database /: maximum performance for your database. (2016)
- Main Title:
- Expert Oracle indexing and access paths : maximum performance for your database
- Further Information:
- Note: Darl Kuhn, Sam R. Alapati, Bill Padfield.
- Authors:
- Kuhn, Darl
Alapati, Sam R
Padfield, Bill - Contents:
- At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Chapter 1: Introduction to Oracle Indexes; Index Basics; Performance Without an Index; Implementing an Index to Improve Performance; Accessing Only the Index; Oracle Ignoring an Index; Index Basics Wrap-up; Determining Which Type of Index to Use; B-tree Indexes; Index-Organized Table; Unique Indexes; Reverse Key Indexes; Key Compressed Indexes; Descending Indexes; Specialized Index Types; Bitmap Index; Bitmap Join; Function-Based Indexes; Indexed Virtual Column; Virtual Index; Invisible Index. Global and Local Partitioned IndexesDomain, B-tree Cluster, and Hash Cluster Indexes; Determining Which Columns to Index; Indexes on Primary Key and Unique Key Columns; Indexes on Foreign Key Columns; Other Suitable Columns; Indexing Guidelines; Summary; Chapter 2: B-tree Indexes; Understanding How Oracle Uses B-tree Indexes; Prepping for B-tree Indexes; Estimating the Size of an Index Before Creation; Creating Separate Tablespaces for Indexes; Inheriting Storage Parameters from the Tablespace; Naming Standards; Implementing B-tree Indexes; Creating a B-tree Index; Reporting on Indexes. Displaying Index CodeDropping a B-tree Index; Managing B-tree Indexes with Constraints; Creating B-tree Index on Primary Key Columns; Use ALTER TABLE to Create a Primary Key Constraint and Index; Use CREATE TABLE to Create a Primary Key Constraint and Index; Create a B-tree Index and Primary Key ConstraintAt a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Chapter 1: Introduction to Oracle Indexes; Index Basics; Performance Without an Index; Implementing an Index to Improve Performance; Accessing Only the Index; Oracle Ignoring an Index; Index Basics Wrap-up; Determining Which Type of Index to Use; B-tree Indexes; Index-Organized Table; Unique Indexes; Reverse Key Indexes; Key Compressed Indexes; Descending Indexes; Specialized Index Types; Bitmap Index; Bitmap Join; Function-Based Indexes; Indexed Virtual Column; Virtual Index; Invisible Index. Global and Local Partitioned IndexesDomain, B-tree Cluster, and Hash Cluster Indexes; Determining Which Columns to Index; Indexes on Primary Key and Unique Key Columns; Indexes on Foreign Key Columns; Other Suitable Columns; Indexing Guidelines; Summary; Chapter 2: B-tree Indexes; Understanding How Oracle Uses B-tree Indexes; Prepping for B-tree Indexes; Estimating the Size of an Index Before Creation; Creating Separate Tablespaces for Indexes; Inheriting Storage Parameters from the Tablespace; Naming Standards; Implementing B-tree Indexes; Creating a B-tree Index; Reporting on Indexes. Displaying Index CodeDropping a B-tree Index; Managing B-tree Indexes with Constraints; Creating B-tree Index on Primary Key Columns; Use ALTER TABLE to Create a Primary Key Constraint and Index; Use CREATE TABLE to Create a Primary Key Constraint and Index; Create a B-tree Index and Primary Key Constraint Separately; Viewing Primary Key Constraint and Index Details; Dropping the Primary Key Constraint and Index; Creating a B-tree Index on Unique Key Columns; Use the ALTER TABLE to Create a Unique Constraint and Index; Use CREATE TABLE to Create a Unique Constraint and Index. Create a B-tree Index and Unique Key Constraint SeparatelyCreating Only a Unique Index; Dropping a Unique Key Constraint and Index; Indexing Foreign Key Columns; Unnecessary Locking; Implementing an Index on a Foreign Key Column; Determining if Foreign Key Columns Are Indexed; Multiple Indexes on the Same Column Combinations; Extended Data Types; Indexing Extended Columns; Virtual Column Solution; Function-Based Index Solution; Summary; Chapter 3: Bitmap Indexes; Understanding Bitmap Indexes; Creating a Bitmap Index; Creating a Partitioned Bitmap Index. Creating a Bitmap Index on an Index-Organized Table Performance Implications of Querying with Bitmap Indexes; Performance Implications of Loading Data with Bitmap Indexes; Understanding Bitmap Join Indexes; Creating a Bitmap Join Index; Duplicating Indexes for Performance; Reporting on Bitmap Indexes; Summary; Chapter 4: Index-Organized Tables; Understanding the Structure; Understanding the Advantages; Creating an Index-Organized Table; Adding an Overflow Segment ; Compressing an Index-Organized Table; Building Secondary Indexes; Rebuilding an Index-Organized Table. … (more)
- Edition:
- Second edition
- Publisher Details:
- Berkeley : Apress
- Publication Date:
- 2016
- Extent:
- 1 online resource
- Subjects:
- 005.74
Computer science
Indexing
Database management
COMPUTERS -- Databases -- General
Database management
Indexing
Computer Science
Database Management
Computers -- Database Management -- General
Databases
Electronic books
Electronic book - Languages:
- English
- ISBNs:
- 9781484219843
1484219848 - Related ISBNs:
- 9781484219836
148421983X - Notes:
- Note: Includes bibliographical references and index.
Note: Online resource; title from PDF title page (EBSCO, viewed October 4, 2016). - Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.368840
- Ingest File:
- 01_351.xml