Use-the-index-luke - use-the-index-luke.com - Use The Index, Luke! blogs
General Information:
Latest News:
Myth: Select * is bad 25 Aug 2013 | 07:41 pm
This is one of the most persistent myths I’ve seen in the field. It’s there for decades. If a myth is alive that long there must be some truth behind it. So, what could be bad about select *? Let’s ha...
Try it online! 13 Aug 2013 | 03:00 am
Today marks the third anniversary of Use The Index, Luke! And I have to fulfill a promise I gave one year ago: You can now test many of the example from this site online at SQLFiddle.com. Here is a t...
About Optimizer Hints 26 Jul 2013 | 03:00 am
Quite often I’m asked what I think about query hints. The answer is more lengthy and probably also more two-fold than most people expect it to be. However, to answer this question once and forever, I ...
Pagination done the PostgreSQL way 18 Jul 2013 | 07:01 pm
Here is another slide deck for my "Pagination done the PostgreSQL way" talk at P2D2.cz. The topic is also relevant for other DBs—PostgreSQL makes it just very easy to demonstrate it. Look here how to ...
Indexes: The neglected performance all-rounder 10 Jul 2013 | 08:41 pm
I think I've actually never shared the slides of my talk given in Paris at Dalibo's PostgreSQL Session about Performance. So, here they are. View at slideshare or download PDF. Original title and au...
Afraid of SSD? 2 Jul 2013 | 05:20 pm
When clients tell me about their plans to invest in SSD storage for their database, they often look at me like a doctor telling a patient about his deadly disease. I didn’t discuss this with my client...
Training and Conference Dates 21 May 2013 | 01:23 pm
A few weeks ago I invited you to take part in a survey about your interest in SQL performance training for developers. In the meanwhile there is a schedule for German and English trainings available. ...
The two top performance problems caused by ORM tools 23 Apr 2013 | 06:53 pm
“ORMs are not entirely useless…” I just tweeted in response to a not exactly constructive message that we should fire developers who want to use ORMs. But than I continued in a not exactly constructiv...
I need your help! 22 Apr 2013 | 05:11 pm
Hi! Would you please spare me a few minutes and help me a little bit? As you might know—or maybe not—I’m making my living as an independent trainer and consultant. Up till now I’ve only delivered on...
Party time 5 Mar 2013 | 12:19 am
Good news everybody. I’m in a good mood today ;) I’ll explain. First of all, the French edition of SQL Performance Explained is almost done and will ship at the end of the month (pre-order now ;). It ...
