I have a sql query in python which is pretty slow, it contain some inner join,
And some one suggest that in this case we can: turn on the "Show Actual Execution Plan" option and then take a close look at what is causing the slowdown.
Here some one has similar prolem as me : Slow SQL Query due to inner and left join?
Does anyone know how can I see the "Actual Execution Plan" and "estimated Execution Plan" in sqlite inside a python script?
I found some defenitions here开发者_如何学编程 : http://www.simple-talk.com/sql/performance/execution-plan-basics/ But still don't know how to do it in python, Any recommendation?
cheers
Atieh
You issue the EXPLAIN query the same as you would any other query.
精彩评论