Question

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

score 155 · Answer 1 · 2025-01-08 04:55:54

155

Views

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

Published on 08 January 2025 at 04:55

score 1.6k · Answer 2 · 2025-01-03 22:53:14

1.6k

Views

Building an sql execution plan history

Published on 03 January 2025 at 22:53

score 357 · Answer 3 · 2025-01-03 23:09:50

357

Views

Update statement taking too long (7 minutes)

Published on 03 January 2025 at 23:09

score 5.8k · Answer 4 · 2025-01-06 00:20:38

5.8k

Views

How can a stored proc have multiple execution plans?

Published on 06 January 2025 at 00:20

score 1.7k · Answer 5 · 2025-01-07 22:21:55

1.7k

Views

Explain Plan output in Oracle

Published on 07 January 2025 at 22:21

score 126 · Answer 6 · 2024-12-20 19:39:06

126

Views

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

Published on 20 December 2024 at 19:39

score 168 · Answer 7 · 2025-01-06 00:20:36

168

Views

Explain plan and computing cache hit ratio in Oracle

Published on 06 January 2025 at 00:20

score 883 · Answer 8 · 2025-01-06 00:11:12

883

Views

SQL Server choosing inefficient execution plan

Published on 06 January 2025 at 00:11

score 94 · Answer 9 · 2025-01-04 22:23:19

94

Views

Sql Server strange execution plan choices

Published on 04 January 2025 at 22:23

score 1.7k · Answer 10 · 2025-01-03 22:36:25

1.7k

Views

EXASOL Explain Analyse Query

Published on 03 January 2025 at 22:36

score 142 · Answer 11 · 2024-12-18 03:42:31

142

Views

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

Published on 18 December 2024 at 03:42

score 177 · Answer 12 · 2024-12-19 11:05:12

177

Views

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

Published on 19 December 2024 at 11:05

score 86 · Answer 13 · 2025-01-06 00:20:36

86

Views

Index not used in query. How to improve performance?

Published on 06 January 2025 at 00:20

score 475 · Answer 14 · 2024-12-19 08:17:10

475

Views

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

Published on 19 December 2024 at 08:17

score 443 · Answer 15 · 2025-01-06 00:11:11

443

Views

Order of execution for TSQL statement with CTE

Published on 06 January 2025 at 00:11

score 82 · Answer 16 · 2025-01-03 22:36:24

82

Views

Execution Plan in SQL Server?

Published on 03 January 2025 at 22:36

score 5.9k · Answer 17 · 2025-01-03 22:21:56

5.9k

Views

Postgres uses wrong index

Published on 03 January 2025 at 22:21

score 106 · Answer 18 · 2025-01-06 00:09:48

106

Views

No orderby in LINQ query, but ORDER BY in SQL

Published on 06 January 2025 at 00:09

score 53 · Answer 19 · 2024-12-19 11:03:24

53

Views

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

Published on 19 December 2024 at 11:03

score 673 · Answer 20 · 2025-01-03 22:37:21

673

Views

Selective XML index query plan

Published on 03 January 2025 at 22:37

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