Expert Oracle indexing and access paths : maximum performance for your database /: maximum performance for your database. (2016)

• Record Type: Book
• 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 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.
• 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.