Question

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

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

86

Views

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

Published on 07 June 2015 at 15:57

score 1.5k · Answer 2 · 2015-06-08 20:32:02

1.5k

Views

Building an sql execution plan history

Published on 08 June 2015 at 20:32

score 308 · Answer 3 · 2015-06-09 16:15:41

308

Views

Update statement taking too long (7 minutes)

Published on 09 June 2015 at 16:15

score 5.7k · Answer 4 · 2015-06-16 15:16:38

5.7k

Views

How can a stored proc have multiple execution plans?

Published on 16 June 2015 at 15:16

score 1.7k · Answer 5 · 2015-06-21 09:41:51

1.7k

Views

Explain Plan output in Oracle

Published on 21 June 2015 at 09:41

score 97 · Answer 6 · 2016-12-12 22:04:46

97

Views

Exact same query and database. In production more than 100x slower

Published on 12 December 2016 at 22:04

score 126 · Answer 7 · 2016-12-08 11:01:58

126

Views

Explain plan and computing cache hit ratio in Oracle

Published on 08 December 2016 at 11:01

score 839 · Answer 8 · 2016-12-19 01:41:21

839

Views

SQL Server choosing inefficient execution plan

Published on 19 December 2016 at 01:41

score 50 · Answer 9 · 2016-12-21 13:19:26

50

Views

Sql Server strange execution plan choices

Published on 21 December 2016 at 13:19

score 1.7k · Answer 10 · 2016-12-20 19:19:06

1.7k

Views

EXASOL Explain Analyse Query

Published on 20 December 2016 at 19:19

score 105 · Answer 11 · 2016-12-22 16:13:00

105

Views

SQL Performance, Execution plan showing mostly Index Scan instead of Index Seek

Published on 22 December 2016 at 16:13

score 167 · Answer 12 · 2016-12-28 09:51:33

167

Views

When filtering a single table on only the primary key, why is the optimizer is doing a full table scan?

Published on 28 December 2016 at 09:51

score 70 · Answer 13 · 2016-12-30 15:38:23

70

Views

Index not used in query. How to improve performance?

Published on 30 December 2016 at 15:38

score 465 · Answer 14 · 2016-12-24 10:07:03

465

Views

left join tables which have same foreign key: hash key probe takes 50%

Published on 24 December 2016 at 10:07

score 431 · Answer 15 · 2017-01-06 16:43:41

431

Views

Order of execution for TSQL statement with CTE

Published on 06 January 2017 at 16:43

score 68 · Answer 16 · 2014-11-18 06:20:42

68

Views

Execution Plan in SQL Server?

Published on 18 November 2014 at 06:20

score 5.9k · Answer 17 · 2014-11-20 10:37:38

5.9k

Views

Postgres uses wrong index

Published on 20 November 2014 at 10:37

score 94 · Answer 18 · 2014-11-19 10:59:42

94

Views

No orderby in LINQ query, but ORDER BY in SQL

Published on 19 November 2014 at 10:59

score 44 · Answer 19 · 2014-11-19 15:02:51

44

Views

Use same plan or pack together several insert statement and get a lot of single use plans?

Published on 19 November 2014 at 15:02

score 657 · Answer 20 · 2014-11-20 17:57:59

657

Views

Selective XML index query plan

Published on 20 November 2014 at 17:57

List Question

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

Building an sql execution plan history

Update statement taking too long (7 minutes)

How can a stored proc have multiple execution plans?

Explain Plan output in Oracle

Exact same query and database. In production more than 100x slower

Explain plan and computing cache hit ratio in Oracle

SQL Server choosing inefficient execution plan

Sql Server strange execution plan choices

EXASOL Explain Analyse Query

SQL Performance, Execution plan showing mostly Index Scan instead of Index Seek

When filtering a single table on only the primary key, why is the optimizer is doing a full table scan?

Index not used in query. How to improve performance?

left join tables which have same foreign key: hash key probe takes 50%

Order of execution for TSQL statement with CTE

Execution Plan in SQL Server?

Postgres uses wrong index

No orderby in LINQ query, but ORDER BY in SQL

Use same plan or pack together several insert statement and get a lot of single use plans?

Selective XML index query plan

Trending Questions

Popular # Hahtags

Popular Questions