- About Optimizer Hints
- August 12–22: Online Training (EU shift)
- Clustered Indexes Dirty Secret
- Didn’t you know?
- FOSDEM Impressions
- Finding All the Red M&Ms
- June 8–18: Online Training (US shift)
- MySQL is to SQL like ??? to NoSQL
- Non-monetary micro sponsoring
- November 11-12 in Frankfurt am Main
- Online-Training in July and August
- Oracle + PostgreSQL
- Oracle Bootcamp
- PDF Registration
- Party time
- PostgreSQL Performance Event
- Quiz Results
- SQL Server Performance Kurs in Stuttgart
- SQL Server performance training in London
- SQLite learnings from PgCon
- Shipping Terms
- Springtime for SQL
- The two top performance problems caused by ORM tools
- Top Tweets January 2013
- Training Survey
- Training and Conference Dates
- Use The Index, Luke
What is "Use The Index, Luke"?
Use The Index, Luke is a guide to SQL performance for developers. The focus is correct index usage because is the (only?) part that developers need to care about.
What is "SQL Performance Explained"?
In 2011, the title "SQL Performance Explained" was also offered as an ePUB pre-release and contained the first two chapters only. The ePUB is still available for free download.
Is it only about the Oracle® database?
The index concepts are very similar in all SQL databases—even though they might have different names. Some sections have a “compatibility” box that explains how the described feature differs in other databases such as MySQL, PostgeSQL, SQL Server and DB2.
The main body uses Oracle terms only for improved readability.
Is it only about B-tree indexes?
Yes — for now.
The B-tree index is the general purpose index type — it's the one created with a plain vanilla
create index statement.
Other index types are not covered in detail because each of them is applicable to only a very specific problem domain:
- Bitmap index
- Used in data warehouse environments. Shortly discussed under "Index Merge: Combining Multiple Indexes".
- Full-text index
- Used for full-text searches only. Shortly discussed under Indexing
- Spatial index
- Used for geospatial queries (e.g., for finding nearby businesses).
How to get updates?
Where is the download?
You can download the first two chapters as part of the ePUB edition which was released in 2011.
What's an ePUB?
EPUB is an open e-book standard. Almost all e-book reader can handle ePUB files.
How can I read an ePUB?
There are many ways to read ePUB e-books, including commercial e-book devices, smartphones and desktop or laptop computers.
Wikipedia has a list of Software Reading Systems (smartphones and desktop) and Hardware Reading Systems (e-book reader).
If your device can't handle ePUB—Amazon Kindle anybody?—there is still the option to convert the ePUB with a tool like Calibre.
The "SQL Performance Explained" ePUB download is DRM free. Please respect the terms of the CC-BY-NC-ND license.
How can I help to promote your site?
Thanks for your help! Here are some ideas:
- Tell your friends (as in face-to-face...it really helps!)
- Link to us from your site or blog
- Ask related questions on Ask.Use-The-Index-Luke.com
- Bookmark us on social sites like Delicious, x-marks, Mr. Wong, etc.
- Write to me with spelling, grammar or other mistakes you find
How can I tell you about spelling or grammar errors?
Please use the contact form.
How can I help financially?
If you want to support me financially, the best way is to contact me about performance consulting. Instant Coaching is just one of the services I offer. Just have a look at my web site winand.at for more information.
Of course you cam also buy the print edition of the book.
Who are you? Who wrote the tutorial?
My about me page has some usefull information about me.
Can you help me with my indexing or performance problems?
Well, yes. There are two ways to get solutions. The first is to ask the community at Ask.Use-The-Index-Luke.com. The site is a community driven so you may or may not get your answer there. Give it a try! The second option is Instant-Coaching service. I can then try to help you via a desktop sharing session, working directly on your issue. With Instant Coaching, there is no need to post your problem for all to read.
Is it "a SQL" or "an SQL"
It depends on your pronounciation. I am saying S-Q-L, hence "an SQL". It seems to be backed by ANSI, as Wikipedia states.
What does "Use The Index, Luke" stand for?
The title refers to the sentence "Use the force, luke" from the Star Wars® movies.
A properly used index is a very powerful tool, just like The Force from the movies.
Privacy: Social Networks
We use third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice or want to know more about your options to not allow this information to be used by these companies, click here.
Privacy: Google Analytics und Google Remarketing
This website uses Google Analytics and Google Remarketing.
A cookie is a piece of information in the form of a very small text file that is placed on an internet user's hard drive. It is generated by a web page server, which is basically the computer that operates a website. The information the cookie contains is set by the server and it can be used by that server whenever the user visits the site. A cookie can be thought of as an internet user's identification card that tells a website when the user has returned. You can disable cookies in your Internet browser.
Google Analytics is a web analytics service provided by Google, Inc. (“Google”). Google Analytics uses “cookies”, which are text files placed on your computer, to help in the analisis of how users use the site. Further information about privacy in Google Analytics is available at http://www.google.com/analytics/learn/privacy.html.