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?
There is no download of the free web-edition, but the book can be bought as PDF for a very modest price: http://sql-performance-explained.com/.
Is there an ePub or Mobi available?
No. Just PDF. In 2011, I've done an ePub of the pre-release of the book and found that I does not give the required control over layout. The book shows many execution plans that cannot be read when not properly formated. ePub and similar formats don't provide enough control to make it readable on all devices. Back that it turned into a support nightmare pretty fast.
If you are unsure if the PDF will work find on your e-device, you can just download the preview (~30 pages) right now and give it a try. You can also buy the PDF edition and return it within 14 if you are not happy.
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 can also buy the print edition of the book.
Who are you? Who wrote the tutorial?
My about me page has some useful 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.