Hello Jwiseh,

I think you yourself given answer in your first post..!!!

All the possible causes that can make slow query performance are mentioned by you.

However, I would like to add one more point (cause for slow query performance):

Query execution plan.

Your query execution plan is also one of the important factor in query slow performance.