This is a mirror of official site: http://jasper-net.blogspot.com/

SQL performance

| Sunday, July 10, 2011
Everything you ever wanted to know about SQL performance. It's really size of book !

  1. Preface — Why is SQL slow?

  2. Anatomy of an Index — What does an Index look like?

    1. The Leaf Nodes — A doubly linked list

    2. The B-Tree — It's a balanced tree

    3. Slow Indexes, Part I — Two ingredients make the index slow

  3. The Where Clause — Indexing to improve search performance

    1. The Equals Operator — Exact key lookup

      1. Surrogate Keys — Single-column indexes

      2. Concatenated Keys — Multi-column indexes

      3. Slow Indexes, Part II — The first ingredient, revisited

    2. Functions — Using functions in the where clause

      1. Case-Insensitive SearchUPPER and LOWER

      2. User Defined Functions — Limitations of function based indexes

      3. Over Indexing — Avoid redundancy

      4. Exercise — How to index by age?

    3. Bind Variables — For security and performance

    4. NULL and Indexes — About Oracle's NULL oddity

      1. Indexing NULL — In the Oracle database

      2. NOT NULL Constraints — How it affects index usage

      3. Partial Indexes, Part I — Oracle's way to partial indexes

    5. Searching for Ranges — Beyond equality

(more.....)

Read more: Use the index, Luke !
QR: table-of-contents

Posted via email from Jasper-net

0 comments: