tailieunhanh - Cost-Based Oracle Fundamentals

Contents at a Glance Foreword About the Author About the Technical Reviewers Acknowledgments Introduction CHAPTER 1 What Do You Mean by Cost? CHAPTER 2 Tablescans CHAPTER 3 Single Table Selectivity CHAPTER 4 Simple B-tree Access CHAPTER 5 The Clustering Factor CHAPTER 6 Selectivity Issues CHAPTER 7 Histograms CHAPTER 8 Bitmap Indexes CHAPTER 9 Query Transformation CHAPTER 10 Join Cardinality CHAPTER 11 Nested Loops CHAPTER 12 | THE EXPERT S VOICE IN ORACLE Cost-Based Oracle Fundamentals The insights thatfonathan provides into the workings of the cost based optimizer trill make a DBA a better designer and a developer a better SQL coder. Both groups trill become better troubleshooters. Thoma Kyle Jonathan Lewis For eMr đ Ờ Tiwnas Kyĩỉ Wee Pre ãent iftMc Sector Grade Corporate Apress Cost-Based Oracle Fundamentals Jonathan Lewis Apress Cost-Based Oracle Fundamentals Copyright 2006 by Jonathan Lewis All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying recording or by any information storage or retrieval system without the prior written permission of the copyright owner and the publisher. ISBN pbk 1-59059-636-6 Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1 Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name we use the names only in an editorial fashion and to the benefit of the trademark owner with no intention of infringement of the trademark. Lead Editor Tony Davis Technical Reviewers Christian Antognini Wolfgang Breitling Editorial Board Steve Anglin Dan Appleman Ewan Buckingham Gary Cornell Tony Davis Jason Gilmore Jonathan Hassell Chris Mills Dominic Shakeshaft Jim Sumser Production Director and Project Manager Grace Wong Copy Edit Manager Nicole LeClerc Senior Copy Editor Ami Knox Assistant Production Director Kari Brooks-Copony Production Editor Katie Stence Compositor Susan Glinert Proofreaders Lori Bring Kim Burton Nancy Sixsmith Indexer Valerie Perry Artist April Milne Cover Designer Kurt Krames Manufacturing Director Tom Debolski Distributed to the book trade worldwide by Springer-Verlag New York Inc. 233 Spring Street 6th Floor New York NY 10013. Phone 1-800-SPRINGER fax 201-348-4505 e-mail orders-ny@ or visit http . For information on translations please .