Expert Indexing in Oracle Database 11g: Maximum Performance by Darl Kuhn, Bill Padfield, Sam R. Alapati

By Darl Kuhn, Bill Padfield, Sam R. Alapati

Specialist Indexing in Oracle Database 11g is ready the single database constitution on the middle of virtually all functionality matters: the index. Database method functionality is among the most sensible matters in details know-how this present day. directors fight to maintain with the explosion of entry and job pushed by way of the proliferation of computing into every thing from telephones to drugs to desktops in our more and more hooked up global. on the center of any good-performing database lies a legitimate indexing process that makes acceptable use of indexing, and particularly of the vendor-specific indexing positive aspects on offer.

Few databases absolutely take advantage of the wealth of knowledge entry mechanisms supplied through Oracle. specialist Indexing in Oracle Database 11g is helping via bringing jointly details indexing and the way to take advantage of it into one, handy and blissfully brief quantity so you might learn quick and feature at your fingertips for reference. study the different sorts of indices to be had and whilst each one is better utilized. realize while queries aren’t utilizing indices as you plan. deal with your indexing for max functionality. allow professional Indexing in Oracle Database 11g be your consultant to deep mastery of the main basic functionality optimization constitution in Oracle Database.

* Explains how indices paintings, how they assist, and the way they hinder
* Demystifies some of the index choices
* Describes the database management chores linked to indices

Show description

Read Online or Download Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database PDF

Best oracle books

Oracle Database 11g New Features

FOREWORD via Tom Kyte Your Must-Have advisor to every little thing New in Oracle Database 11gRealize the entire power of Oracle Database 11g with support from the specialists. Written by way of Robert G. Freeman, and with insightful remark all through from Arup Nanda, this Oracle Press advisor deals complete information at the architectural adjustments, database management improvements, availability and restoration revisions, safety improvements, and programming recommendations.

Oracle Database 10g, A Beginner's Guide

Presents starting DBAs and builders with a fantastic starting place within the database management and programming fundamentals had to embark on an Oracle profession. the point of interest is on Oracle Database 10g, yet you’ll get the basics appropriate to all Oracle database releases.

Pro Oracle Database 12c Administration

Seasoned Oracle Database 12c management is a ebook excited about effects. writer Darl Kuhn attracts from a good of expertise over a decade deep to put out real-world strategies that result in luck as an Oracle Database administrator. He provides transparent reasons on tips on how to practice serious initiatives. He weaves in idea the place important with no bogging you down in unneeded element.

Oracle Application Express for Mobile Web Applications

Oracle program show is celebrated within the Oracle neighborhood as a useful tool for developing net purposes compatible for computing device browsers. positive factors have now been extra to open up the realm of cellular shopping, bringing the simplicity and expressiveness of Appliction convey to endure in constructing purposes to run with an almost-native feel and appear on structures reminiscent of iOS, Android, and home windows cellphone.

Extra resources for Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database

Example text

Make the index unusable. The idea is to try to determine beforehand that the index is not used for any purpose before actually dropping it. See Chapter 7 for details on monitoring an index. Monitoring an index will give you an idea if the application is using it for SELECT statements. Index monitoring will not tell you if the index is used for other internal purposes, like enforcing a constraint or preventing locking issues. Making an index invisible requires Oracle Database 11g. An invisible index is still maintained by Oracle but isn’t considered by the query optimizer when determining the execution plan.

A well planned indexing strategy results in a well performing database application. Conversely, a careless plan will result in poor performance. Indexes consume space on disk and are stored separately from tables. However, indexes are defined on a table and one or more columns; in this sense, an index can’t exist without the table. Oracle provides a wide number of indexing types and features. In most situations, the default B-tree index is appropriate. Before using other index types, make sure you understand the performance benefits.

Given those needs, here are some sample index-naming guidelines: • Primary-key index names should contain the table name and a suffix such as _PK. • Unique-key index names should contain the table name and a suffix such as _UKN, where N is a number. • Indexes on foreign-key columns should contain the foreign-key table and a suffix such as _FKN, where N is a number. • For indexes that aren’t used for constraints, use the table name and a suffix such as _IDXN, where N is a number. • Function-based index names should contain the table name and a suffix such as _FCN, where N is a number.

Download PDF sample

Rated 4.07 of 5 – based on 5 votes