Use The Index, Luke


 

A Guide to SQL Performance by Markus Winand

Just what developers need to know

 

DB2 is a registered trademark of IBM Corporation.

Oracle, Java and MySQL are registered trademarks of Oracle and/or its affiliates.

Microsoft and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

PostgreSQL is a registered trademark of PostgreSQL Global Development Group.

THIS INFORMATION IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND BY ANY PERSON,. INCLUDING WITHOUT LIMITATION, THE OWNER AND THE PUBLISHER.

Contents

About the Author

As an author, trainer, and coach Markus Winand specializes in helping developers cope with SQL performance issues. He also published the book SQL Performance Explained and tweets his best performance tips via @SQLPerfTips.http://winand.at/

Recent Questions at Ask.Use-The-Index-Luke.com

0
votes
1
answer
1.2k
views
0
votes
1
answer
1.4k
views

query regd the CBO decision

May 10 at 08:57 dsfsfe(suspended)
index-choice optimizer
0
votes
1
answer
251
views

Index search using the concatenated index and SECOND column in WHERE clause.

Apr 15 at 13:45 Markus Winand ♦♦ 321
postgres