Questions about sql-execution-plan
Read more about sql-execution-plan
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
MySQL Explain plain doesn't show index used when it should be
I'm trying to run a query in MySQL that's timing out after a couple of minutes on a QA system with 8 million+ rows. It runs fine for me locally, but obviously less data.
Here's the query:
SELECT
...
Jack BeNimble
Votes: 0
Answers: 0
Why Estimated Execution Plan shows clustered index scan instead of table scan?
I have very simple table like this :
It contains only one clustered index on ID column (PRIMARY KEY) as you can see.
Data that are stored in that table :
When I do Display Estimated Execution Plan i...
Dear Deer
Votes: 0
Answers: 0
SQL Query Execution Plan and Performance difference between 2 servers but query is same
Problem I am trying to solve is a query that on one server executes in 1 second but on another server it takes 10-20 seconds. Server one is a nightly replication of server 2 so pretty much everything ...
JetRocket11
Votes: 0
Answers: 1
What might cause Oracle to choose parallel execution on one database versus the other for the same objects?
I have a test and development Oracle 19c database that is running out of temp tablespace on an older pre-existing query. The explain plan shows that, on the database running out of space, the explain ...
mkohanek
Votes: 0
Answers: 1