TechQA.

Question

Why does mysql stop using indexes when date ranges are added to the query?

score 96 · Answer 1 · 2015-06-07 15:57:45

0

Answer

96

Views

Why does mysql stop using indexes when date ranges are added to the query?

96 views Asked by Alex R At 07 June 2015 at 15:57

score 73 · Answer 2 · 2015-06-15 17:37:55

SQL Server - Substitute for OR when JOINing on non-indexed field

73 views Asked by aleppke At 15 June 2015 at 17:37

score 460 · Answer 3 · 2015-06-18 13:34:07

Faster selects on large table with shredded/flattened xml field

460 views Asked by Matma At 18 June 2015 at 13:34

score 87 · Answer 4 · 2015-06-23 11:22:26

Lot of full table scans (around 600) because of a simple IN statement

87 views Asked by Lóri Nóda At 23 June 2015 at 11:22

score 83 · Answer 5 · 2015-06-23 23:25:55

Scaling MySQL database, increasing performance to many connections

83 views Asked by Hugo Ferreira At 23 June 2015 at 23:25

score 1182 · Answer 6 · 2015-06-25 04:28:10

Taxi Driver Queue management MySQL query

1.1k views Asked by Adnan At 25 June 2015 at 04:28

score 7136 · Answer 7 · 2015-06-25 17:08:59

Clear MySQL Cache

7.1k views Asked by hogan At 25 June 2015 at 17:08

score 89 · Answer 8 · 2016-12-14 16:16:32

Improve performance of a sql query

89 views Asked by NonProgrammer At 14 December 2016 at 16:16

score 2878 · Answer 9 · 2016-12-17 12:55:38

query optimization for max function in oracle

2.8k views Asked by Piyush Diwakar At 17 December 2016 at 12:55

score 133 · Answer 10 · 2016-12-19 10:17:13

Bottle neck on SORT operation

133 views Asked by Philip At 19 December 2016 at 10:17

TechQA.

List Question

Why does mysql stop using indexes when date ranges are added to the query?

SQL Server - Substitute for OR when JOINing on non-indexed field

Faster selects on large table with shredded/flattened xml field

Lot of full table scans (around 600) because of a simple IN statement

Scaling MySQL database, increasing performance to many connections

Taxi Driver Queue management MySQL query

Clear MySQL Cache

Improve performance of a sql query

query optimization for max function in oracle

Bottle neck on SORT operation

Popular Questions

Popular Tags

Trending Questions