Markus Winand

Markus Winand has asked 0 questions and find answers to 39 problems.

Stats

About

Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing—for that he also published the book SQL Performance Explained.

Markus Winand questions

Markus Winand answers

What kind of index for orderby/where query in SQL?
How to properly index a many-many association table?
MySQL performance gain by reducing index size?
Postgres ignoring clustered index on date query
How to use index efficienty in mysql query
Should I always prefer working with prepared SQL statements, for performance benefits?
SQL server filtered indexes
Using the "IN" clause with a comma delimited string from the output of a replace() function in Oracle SQL
SQL queries within a loop
Why "first" or "any" aggregate functions are not commonly used in database engines?