SQL performance

Everything you ever wanted to know about SQL performance. It's really size of book !

0. Preface — Why is SQL slow?

1. 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

2. 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 Search — UPPER 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:

Posted via email from Jasper-net