374 reputation
14
bio website winand.at
location Vienna, Austria
age
visits member for 2 years, 9 months
seen Apr 16 at 5:26

Hi!

I'm Markus and I'm running a business where I'm tuning developers for high SQL performance.

For that, I've also written the book SQL Performance Explained which is also available in German and French. Oh, btw, the complete content of the book also available for free on my site http://Use-The-Index-Luke.com/.


Jan
21
awarded  Custodian
Jan
21
reviewed Approve suggested edit on why would rebuild index reduce btree leaf numbers
Jan
21
answered why would rebuild index reduce btree leaf numbers
Jan
20
comment Why is multiple independent index always better than concatenated index
@JürgenStrobel If you think so, prove it.
Jan
20
comment Why is multiple independent index always better than concatenated index
@JürgenStrobel sorry, I just don't see your argument. I'm talking about two facts: (1) one index lookup if faster than two; (2) combining the result of two index lookups needs resources too.
Jan
20
comment Why is multiple independent index always better than concatenated index
@JürgenStrobel Have you read the linked article? use-the-index-luke.com/sql/where-clause/searching-for-ranges/… Sure there are exceptions, but for the majority it is clearly better.
Jan
20
answered Why is multiple independent index always better than concatenated index
May
7
awarded  Yearling
Apr
9
answered Should I seperate frequently updated columns
Feb
3
awarded  Critic
Nov
17
awarded  Teacher
Nov
15
answered Are these good indexing guidelines?
Aug
15
awarded  Supporter