Markus Winand questions

Markus Winand answers

• How to find number of database round trips by an application
• Reversing a string using an index in Oracle
• 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