FAQ



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"?

"SQL Performance Explained" is the print edition of "Use The Index, Luke". It is available in English and German language from SQL-Performance-Explained.com and SQL-Performance-Explained.de

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 LIKE Filters.
Spatial index
Used for geospatial queries (e.g., for finding nearby businesses).

How to get updates?

You can follow the RSS feed, one of my Twitter accounts @MarkusWinand, @SQLPerfTips, or Facebook.

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.

If all of that isn't for you, but you still want to give, just flattr me. Never heard of it? Here is a YouTube video explaining how it works.

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

Use-The-Index-Luke.com does not include external resources (images, JavaScript) from social networks. The buttons provided by most social media websites do not work without connecting to the social media site itself. To protect privacy and still provide a—more or less—convenient way to use social media, an overlay window opens if you click those buttons. Only then does your browser connects to the social media site—only if you want to contact that site anyway.We do include resources from Google as described below.

Privacy: Ads

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.

Cookies

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

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.

Google Remarketing

Here, Google Inc. collates information relating to your visit to our website. For this, Google uses cookies, which are text files that are stored on your computer. Within the context of remarketing, such cookies are used – on the basis of your visit to our website – to show you online advertising for our products and services when you visit other Websites. You can Opt-Out of this "interested-based advertising" via Google, or alternatively you can use the Opt-Out function of the Opt-Out function of the Network Advertising Initiative.

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
135
views

We want to buy the book but I can't

Jul 18 at 21:36 Markus Winand ♦♦ 541
book
0
votes
2
answers
157
views
0
votes
0
answers
820
views

Performance very bad in Postgresql 9.3

Jul 08 at 11:54 Markus Winand ♦♦ 541
performance issue