000761496 000__ 04628cam\a2200541Ii\4500 000761496 001__ 761496 000761496 005__ 20230306142159.0 000761496 006__ m\\\\\o\\d\\\\\\\\ 000761496 007__ cr\cn\nnnunnun 000761496 008__ 160929s2016\\\\cau\\\\\o\\\\\001\0\eng\d 000761496 019__ $$a961002731 000761496 020__ $$a9781484219843$$q(electronic book) 000761496 020__ $$a1484219848$$q(electronic book) 000761496 020__ $$z9781484219836 000761496 020__ $$z148421983X 000761496 035__ $$aSP(OCoLC)ocn959554402 000761496 035__ $$aSP(OCoLC)959554402$$z(OCoLC)961002731 000761496 040__ $$aN$T$$beng$$erda$$epn$$cN$T$$dN$T$$dIDEBK$$dEBLCP$$dGW5XE$$dYDX 000761496 049__ $$aISEA 000761496 050_4 $$aQA76.9.D3 000761496 08204 $$a005.74$$223 000761496 1001_ $$aKuhn, Darl,$$eauthor. 000761496 24500 $$aExpert Oracle indexing and access paths :$$bmaximum performance for your database /$$cDarl Kuhn, Sam R. Alapati, Bill Padfield. 000761496 250__ $$aSecond edition. 000761496 264_1 $$a[Berkeley] :$$bApress$$c2016. 000761496 300__ $$a1 online resource. 000761496 336__ $$atext$$btxt$$2rdacontent 000761496 337__ $$acomputer$$bc$$2rdamedia 000761496 338__ $$aonline resource$$bcr$$2rdacarrier 000761496 4901_ $$aThe expert's voice in Oracle 000761496 500__ $$aIncludes index. 000761496 5050_ $$aAt 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 000761496 5058_ $$aGlobal 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 000761496 5058_ $$aDisplaying 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 000761496 5058_ $$aCreate 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 000761496 5058_ $$aCreating 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 000761496 506__ $$aAccess limited to authorized users. 000761496 588__ $$aOnline resource; title from PDF title page (viewed October 4, 2016) 000761496 63000 $$aOracle (Computer file) 000761496 650_0 $$aIndexing. 000761496 650_0 $$aDatabase management. 000761496 7001_ $$aAlapati, Sam R.,$$eauthor. 000761496 7001_ $$aPadfield, Bill,$$eauthor. 000761496 830_0 $$aExpert's voice in Oracle. 000761496 852__ $$bebk 000761496 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-1984-3$$zOnline Access$$91397441.1 000761496 909CO $$ooai:library.usi.edu:761496$$pGLOBAL_SET 000761496 980__ $$aEBOOK 000761496 980__ $$aBIB 000761496 982__ $$aEbook 000761496 983__ $$aOnline 000761496 994__ $$a92$$bISE