KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
sql-execution-plan
24 questions
Follow Tag
Sort by:
Newest
Votes
Active
15
votes
7
answers
Very slow DELETE query
sql
sql-server
performance
sql-execution-plan
table-variable
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