Copyright

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and Addison-Wesley, Inc. was aware of a trademark claim, the designations have been printed with initial capital letters or in all capitals.

The authors and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

The publisher offers discounts on this book when ordered in quantity for bulk purchases and special sales. For more information, please contact:

U.S. Corporate and Government Sales

[phone]

[e-mail]

For sales outside of the U.S., please contact:

International Sales

[phone]

[e-mail]

Visit A-W on the Web: www.awprofessional.com

Library of Congress Cataloging-in-Publication Data

Gulutzan, Peter.

SQL performance tuning / Peter Gulutzan and Trudy Pelzer.

p. m.

Includes bibliographical references and index.

ISBN 0-201-79169-2 (alk. paper)

1. SQL (Computer program language) 2. Relational databases. I. Pelzer, Trudy. II. Title.

QA76.73.S67 G853 2003

005.75'6dc21

2002074418

Copyright 2003 Pearson Education, Inc

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form, or by any means, electronic, mechanical, photocopying, recording, or otherwise , without the prior consent of the publisher. Printed in the United States of America. Published simultaneously in Canada.

For information on obtaining permission for use of material from this work, please submit a written request to:

Pearson Education, Inc.

Rights and Contracts Department

75 Arlington Street, Suite 300

Boston, MA 02116

Fax: [phone]

Text printed on recycled paper

1 2 3 4 5 6 7 8 9 10CRS0605040302

First printing, September 2002