Website review use-the-index-luke.com
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
Generated on March 10 2026 14:22 PM
Old data? UPDATE !
The score is 65/100
SEO Content
Title
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
Length : 116
Ideally, your title should contain between 10 and 70 characters (spaces included). Use this free tool to calculate text length.
Description
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.
Length : 147
Great, your meta description contains between 70 and 160 characters.
Keywords
Very bad. We haven't found meta keywords on your page. Use this free online meta tags generator to create keywords.
Og Meta Properties
Good, your page take advantage of Og Properties.
| Property | Content |
|---|---|
| title | SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ... |
| description | SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases. |
| image | https://use-the-index-luke.com/static/util_squirrel.og.fMeqdSQq.png |
Headings
| H1 | H2 | H3 | H4 | H5 | H6 |
| 1 | 10 | 0 | 0 | 0 | 0 |
- [H1] SQL Indexing and Tuning e-Book
- [H2] SQL Indexing in MySQL, Oracle, SQL Server, etc.
- [H2] Table of Contents
- [H2] About the Author
- [H2] Buy the Book
- [H2] Hire Markus
- [H2] The 3-Minute Quiz
- [H2] Table of Contents
- [H2] Latest Blog Posts
- [H2] Geek Ware
- [H2] Connect with Markus Winand
Images
We found 3 images on this web page.
Good, most or all of your images have alt attributes.
Text/HTML Ratio
Ratio : 35%
Ideal! This page's ratio of text to HTML code is between 25 and 70 percent.
Flash
Perfect, no Flash content has been detected on this page.
Iframe
Great, there are no Iframes detected on this page.
SEO Links
URL Rewrite
Bad. Your links have query string.
Underscores in the URLs
We have detected underscores in your URLs. You should rather use hyphens to optimize your SEO.
In-page links
We found a total of 87 links including 2 link(s) to files
| Anchor | Type | Juice |
|---|---|---|
| DE | Internal | Passing Juice |
| FR | Internal | Passing Juice |
| ES | Internal | Passing Juice |
| JA | Internal | Passing Juice |
| Markus Winand | Internal | Passing Juice |
| winand.at | External | Passing Juice |
| Preface | Internal | Passing Juice |
| Anatomy of an Index | Internal | Passing Juice |
| The Leaf Nodes | Internal | Passing Juice |
| The B-Tree | Internal | Passing Juice |
| Slow Indexes, Part I | Internal | Passing Juice |
| The Where Clause | Internal | Passing Juice |
| The Equals Operator | Internal | Passing Juice |
| Primary Keys | Internal | Passing Juice |
| Concatenated Keys | Internal | Passing Juice |
| Slow Indexes, Part II | Internal | Passing Juice |
| Functions | Internal | Passing Juice |
| Case-Insensitive Search | Internal | Passing Juice |
| User-Defined Functions | Internal | Passing Juice |
| Over-Indexing | Internal | Passing Juice |
| Bind Variables | Internal | Passing Juice |
| Searching for Ranges | Internal | Passing Juice |
| Index Combine | Internal | Passing Juice |
| Partial Indexes | Internal | Passing Juice |
| Emulating Partial Indexes | Internal | Passing Juice |
| Obfuscated Conditions | Internal | Passing Juice |
| Dates | Internal | Passing Juice |
| Numeric Strings | Internal | Passing Juice |
| Combining Columns | Internal | Passing Juice |
| Smart Logic | Internal | Passing Juice |
| Math | Internal | Passing Juice |
| Testing and Scalability | Internal | Passing Juice |
| Data Volume | Internal | Passing Juice |
| System Load | Internal | Passing Juice |
| Response Time and Throughput | Internal | Passing Juice |
| The Join Operation | Internal | Passing Juice |
| Nested Loops | Internal | Passing Juice |
| Hash Join | Internal | Passing Juice |
| Sort-Merge Join | Internal | Passing Juice |
| Clustering Data | Internal | Passing Juice |
| Index Filter Predicates Intentionally Used | Internal | Passing Juice |
| Index-Only Scan | Internal | Passing Juice |
| Index-Organized Table | Internal | Passing Juice |
| Sorting and Grouping | Internal | Passing Juice |
| Indexed Order By | Internal | Passing Juice |
| Indexed Group By | Internal | Passing Juice |
| Partial Results | Internal | Passing Juice |
| Selecting Top-N Rows | Internal | Passing Juice |
| Fetching The Next Page | Internal | Passing Juice |
| Window-Functions | Internal | Passing Juice |
| Insert, Delete and Update | Internal | Passing Juice |
| Insert | Internal | Passing Juice |
| Delete | Internal | Passing Juice |
| Update | Internal | Passing Juice |
| External | Passing Juice | |
| Bluesky | External | Passing Juice |
| RSS | Internal | Passing Juice |
| modern-sql.com | External | Passing Juice |
| use-the-index-luke.com | Internal | Passing Juice |
| winand.at | External | Passing Juice |
| Buy now! | Internal | Passing Juice |
| Amazon.com | External | Passing Juice |
| The 3-Minute Quiz | Internal | Passing Juice |
| Table of Contents | Internal | Passing Juice |
| Execution Plans | Internal | Passing Juice |
| Myth Directory | Internal | Passing Juice |
| Example Schema | Internal | Passing Juice |
| Glossary | Internal | Passing Juice |
| Latest Blog Posts | Internal | Passing Juice |
| Automatic Rewrite of Date and Time Ranges | Internal | Passing Juice |
| Upcoming Training: SQL Performance Kick-Start and modern SQL | Internal | Passing Juice |
| Spanish Anyone? | Internal | Passing Juice |
| News Review: Cloud Wars, IBM’s Renaming Insanity, and Three Major Releases | Internal | Passing Juice |
| Big News: new SQL standard, cloud wars, ACIDRain | Internal | Passing Juice |
| Big News in Databases | Internal | Passing Juice |
| On Uber’s Choice of Databases | Internal | Passing Juice |
| Modern SQL in PostgreSQL [and other databases] | Internal | Passing Juice |
| Geek Ware | Internal | Passing Juice |
| Stickers | Internal | Passing Juice |
| Coasters | Internal | Passing Juice |
| Books | Internal | Passing Juice |
| Mugs | Internal | Passing Juice |
| Legal | Internal | Passing Juice |
| Contact | Internal | Passing Juice |
| NO WARRANTY | Internal | Passing Juice |
| Trademarks | Internal | Passing Juice |
| Privacy and GDPR | Internal | Passing Juice |
SEO Keywords
Keywords Cloud
oracle like sql winand markus indexing covers luke index indexes
Keywords Consistency
| Keyword | Content | Title | Keywords | Description | Headings |
|---|---|---|---|---|---|
| sql | 28 |  |
 |
|
|
| index | 22 | |
|
|
|
| indexing | 21 | |
|
|
|
| markus | 11 | |
|
|
|
| indexes | 11 | |
|
|
|
Usability
Url
Domain : use-the-index-luke.com
Length : 22
Favicon
Great, your website has a favicon.
Printability
We could not find a Print-Friendly CSS.
Language
Good. Your declared language is en.
Dublin Core
This page does not take advantage of Dublin Core.
Document
Doctype
HTML 5
Encoding
Perfect. Your declared charset is UTF-8.
W3C Validity
Errors : 0
Warnings : 0
Email Privacy
Great no email address has been found in plain text!
Deprecated HTML
Great! We haven't found deprecated HTML tags in your HTML.
Speed Tips
|
Excellent, your website doesn't use nested tables. |
|
Too bad, your website is using inline styles. |
|
Great, your website has few CSS files. |
|
Perfect, your website has few JavaScript files. |
|
Perfect, your website takes advantage of gzip. |
Mobile
Mobile Optimization
|
Apple Icon |
|
Meta Viewport Tag |
|
Flash content |
Optimization
XML Sitemap
Great, your website has an XML sitemap.
| https://use-the-index-luke.com/sitemap.xml |
Robots.txt
https://use-the-index-luke.com/robots.txt
Great, your website has a robots.txt file.
Analytics
Missing
We didn't detect an analytics tool installed on this website.
Web analytics let you measure visitor activity on your website. You should have at least one analytics tool installed, but It can also be good to install a second in order to cross-check the data.
PageSpeed Insights
Device
Categories
Free SEO Testing Tool
Free SEO Testing Tool is a free SEO tool which provides you content analysis of the website.