|
Books > Computing & IT > Computer software packages > Database software > Oracle
|
Buy Now
Expert Oracle Indexing and Access Paths - Maximum Performance for Your Database (Paperback, 2nd ed.)
Loot Price: R3,249
Discovery Miles 32 490
|
|
|
Expert Oracle Indexing and Access Paths - Maximum Performance for Your Database (Paperback, 2nd ed.)
Expected to ship within 10 - 15 working days
|
Speed up the execution of important database queries by making good
choices about which indexes to create. Choose correct index types
for different scenarios. Avoid indexing pitfalls that can actually
have indexes hurting performance rather than helping. Maintain
indexes so as to provide consistent and predictable query response
over the lifetime of an application. Expert Oracle Indexing and
Access Paths is about the one database structure at the heart of
almost all performance concerns: the index. Database system
performance is one of the top concerns in information technology
today. Administrators struggle to keep up with the explosion of
access and activity driven by the proliferation of computing into
everything from phones to tablets to PCs in our increasingly
connected world. At the heart of any good-performing database lies
a sound indexing strategy that makes appropriate use of indexing,
and especially of the vendor-specific indexing features on offer.
Few databases fully exploit the wealth of data access mechanisms
provided by Oracle. Expert Oracle Indexing and Access Paths helps
by bringing together information on indexing and how to use it into
one blissfully short volume that you can read quickly and have at
your fingertips for reference. Learn the different types of indexes
available and when each is best applied. Recognize when queries
aren't using indexes as you intend. Manage your indexing for
maximum performance. Confidently use the In Memory column store
feature as an alternate access path to improve performance. Let
Expert Indexing in Oracle Database 12c be your guide to deep
mastery of the most fundamental performance optimization structure
in Oracle Database. Explains how indexes help performance, and
sometimes hinder it too Demystifies the various index choices so
that you can chose rightly Describes the database administration
chores associated with indexes Demonstrates the use of the In
Memory column store as an alternate access path to the data What
You Will Learn Create an overall indexing strategy to guide your
decisions Choose the correct indexing mechanisms for your
applications Manage and maintain indices to avoid degradation and
preserve efficiency Take better advantage of underused index types
such as index-organized tables Choose the appropriate columns to
index, with confidence Blend partitioning and materialized views
into your indexing strategy Who This Book Is For All levels of
database administrators and application developers who are
struggling with the database performance and scalability challenge.
Any database administrator involved with indexing, which is any
database administrator period, will appreciate the wealth of advice
packed into this gem of a book.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
You might also like..
|
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
