Questions tagged [sql-execution-plan]

15

votes

7

answers

Very slow DELETE query

asked 2013-05-23T12:59:55.473

24

votes

4

answers

Missing STOPKEY per partition in Oracle plan for paging by local index

sql oracle-database prepared-statement partitioning sql-execution-plan

asked 2013-03-12T09:32:26.120

18

votes

2

answers

Why is Oracle ignoring index with ORDER BY?

sql performance oracle-database database-performance sql-execution-plan

asked 2012-11-21T16:38:51.727

8

votes

2

answers

PostgreSQL: The lower the LIMIT, the slower the query

sql postgresql query-optimization sql-execution-plan

asked 2012-07-26T12:30:06.640

8

votes

3

answers

What's the difference between these T-SQL queries using OR?

sql-server sql-server-2008 database-performance sql-execution-plan

asked 2012-03-13T11:45:05.073

13

votes

2

answers

Large amount of projected I/O with Oracle, even if only a single record is fetched

sql performance oracle-database oracle11g sql-execution-plan

asked 2012-03-12T17:03:32.987

8

votes

1

answers

DBMS_XPLAN.DISPLAY_CURSOR vs Explain Plan if not using gather_plan_statistics hint

sql performance oracle-database oracle11g sql-execution-plan

asked 2012-02-22T03:49:18.657

9

votes

5

answers

Execution plan over query with temp tables

sql-server sql-server-2008-r2 sql-execution-plan

asked 2012-01-11T16:29:00.403

13

votes

2

answers

Non-negligible execution plan difference with Oracle when using jdbc Timestamp or Date

oracle-database jdbc timestamp sql-execution-plan

asked 2011-07-07T14:58:09.357

20

votes

5

answers

Why is this an Index Scan and not a Index Seek?

performance t-sql sql-server-2008 indexing sql-execution-plan

asked 2011-06-30T00:51:21.893

9

votes

2

answers

Same query - different execution plans

sql sql-server sql-server-2008 query-optimization sql-execution-plan

asked 2011-05-06T03:12:03.803

14

votes

1

answers

Tools for visualising execution xml plans as HTML

sql-server sql-execution-plan

asked 2011-01-26T00:48:18.330

9

votes

3

answers

SQL Server sp_ExecuteSQL and Execution Plans

sql sql-server sql-server-2005 t-sql sql-execution-plan

asked 2010-09-14T15:47:44.743

11

votes

1

answers

Explain Vs Desc anomalies in mysql

mysql sql-execution-plan describe

asked 2010-06-23T08:58:22.710

9

votes

3

answers

How do I explain a query with parameters in MySQL

mysql sql-execution-plan

asked 2010-06-16T16:56:19.083

12

votes

3

answers

MySQL, delete and index hint

mysql query-optimization sql-delete sql-execution-plan

asked 2010-05-27T20:33:14.250

53

votes

7

answers

Meaning of "Select tables optimized away" in MySQL Explain plan

sql mysql performance query-optimization sql-execution-plan

asked 2010-01-02T18:18:01.190

42

votes

9

answers

How to improve performance on a clustered index seek

sql sql-server query-performance sql-execution-plan

asked 2009-12-28T19:15:08.683

16

votes

1

answers

Getting rid of Table Spool in SQL Server Execution plan

sql sql-server sql-execution-plan

asked 2009-12-18T22:39:11.590

36

votes

5

answers

Reset SQL Server execution plan

sql-server sql-execution-plan

asked 2009-11-03T16:18:36.500

63

votes

14

answers

Faster way to delete matching rows?

mysql performance sql-delete sql-execution-plan

asked 2009-05-01T18:12:09.083

26

votes

9

answers

Performance of SQL "EXISTS" usage variants

sql sql-execution-plan

asked 2009-01-08T13:27:50.307

64

votes

1

answers

What is the difference between Seq Scan and Bitmap heap scan in postgres?

optimization postgresql query-optimization sql-execution-plan

asked 2009-01-04T06:52:44.523

94

votes

11

answers

How do you interpret a query's explain plan?

sql database performance oracle-database sql-execution-plan

asked 2008-09-17T02:26:18.930

Questions tagged sql-execution-plan