Indexing Beyond the Basics

I repeatedly see the same misconceptions and need for practical knowledge about indexes. You only find introductory stuff but nothing for real applications.

[Indexing Beyond the Basics @IndexingBook]

This book is a novel approach to learning everything you need to understand about indexes:

👉 Teaches reusable principles instead of examples
👉 Does not bore with excessive technical explanations
👉 Uses many images to clarify concepts

https://t.co/IYvUSalNQO

[Mohamed Allam @MohamedTechie]

@wangbin579 @tobias_petry has an excellent book on index
For those who want a framework on specifically how to use the index properly.

[Bernhard Kraemer @bernhardkraemer]

Just bought it and if you want to improve your database performance skills, you should, too!

[Hernán Valdez @hernanAvaldez]

Even if you know indexes, the way Tobias explains them makes the book worth buying. Each lesson has its own examples, real world examples.
Go grab a copy!

[Tobias_Petry.sql @tobias_petry]

My book is now available with a 50% Black Friday discount 🔥

The team packages are now also included: Performance shouldn't be the task of a single person in a team!

https://t.co/7pweT0kBMs

[Tobias_Petry.sql @tobias_petry]

I started working on the next batch of chapters for the @IndexingBook

I share the draft of this indexing myth to everyone who requested free chapters tomorrow.

[Matija Barić @1Crodev]

In short if you did not understand indexes or even better you don't understand it at all, here is your chance to learn it in easy way. Thank you Tobias @IndexingBook

[Sean Kegel @sean_kegel]

Just finished reading Indexing Beyond the Basics and it was fantastic. Highly recommend for anyone want to learn more about database indexing. Great job @tobias_petry!

[Tobias_Petry.sql @tobias_petry]

You need a good and short literature for your vacation? One that you'll definetely no take home unfinished?

My book is intentionally kept short but packed full of stuff you need to learn!

And some people even print it 😅

[Hassan Zahirnia @HassanZahirnia]

✨ Designed this dashboard for @tobias_petry's @IndexingBook 📖

👉 Check it out to read the book online, download files, watch videos, and manage team licenses.

Let me know if you have any feedback. 😊

[Tobias_Petry.sql @tobias_petry]

Your SQL query is slow and you need to create an index. But which one?

An index on a single column is wrong 99% of the time...

👇 Learn with 5 tweets why you always need a multi-column index

[Tobias_Petry.sql @tobias_petry]

The best validation you can have:

A developer liked my indexing book and talked about it at their company. The other developers were then interested in it, and the company decided to get it for the entire dev team.

The result? A 34-person team license! 🤓

[Tobias_Petry.sql @tobias_petry]

Writing is really hard. And doing a break to relax some time makes it even harder to start again.

So I am happy that I finally broke the writer's block and wrote new chapters for the @IndexingBook 🎉

I am embarassed it took so long for the first update🙈

[Tobias_Petry.sql @tobias_petry]

I didn't expect the massive success when I started writing the @IndexingBook

But tonight I passed the $100k USD milestone. Absolutely unbelievable 🤯

Am I still dreaming or am I awake? 😅

[Pert Soomann @PerttiSoomann]

That's my weekend reading sorted out 🤓

[Indexing Beyond the Basics @IndexingBook]

@PerttiSoomann So, how was your weekend reading? Enlightening?

[Tobias_Petry.sql @tobias_petry]

🎁 The @IndexingBook Black Friday Deal is live!

You can now get the book heavily discounted:
👉 Only the Essentials: $79 instead of $99
👉 The Full Experience: $119 instead of $179

Future updates at are all free - and many are planned for next year 😉

https://t.co/TGARXtzRcN

[Tobias_Petry.sql @tobias_petry]

Another one happy with the @IndexingBook 😃

[Tobias_Petry.sql @tobias_petry]

🥳 I've released the online version of the @IndexingBook. I believe it's the best reading experience together with the ePUB version for e-book readers.

What do you think? Isn't it beautiful?

[Tobias_Petry.sql @tobias_petry]

Thanks to TailwindUI, the online version of the @IndexingBook will be excellent to read.

And, more importantly, to look up stuff all the time when needed.

It should be finished next week 😃

[Tobias_Petry.sql @tobias_petry]

🔥 Last 24 hours to get the launch discount!

https://t.co/KXBEqHtaNK