UNCACHEABLE SUBQUERY

Question

Can anyone please tell me what is UNCACHEABLE SUBQUERY in MySQL?

How it is different from DEPENDENT SUBQUERY?

By what criteria does MySQL consider a subquery an UNCACHEABLE SUBQUERY?

What's the query in question? – Devon Bessemer Nov 18 '14 at 05:39 — Devon Bessemer, Nov 18 '14 at 05:39

score 0 · Answer 1 · edited May 23 '17 at 11:57

0

Relevant: Cache/Re-Use a Subquery in MySQL which is also the first result on Google if you had done some research.

Shows if a query uses session variables or is a correlated subquery. A correlated subquery is a subquery that relies on variables from the primary query and can not be run independently. (So if you can't run the subquery separately, then it is correlated)

edited May 23 '17 at 11:57

Community

1
1

answered Nov 18 '14 at 05:43

Devon Bessemer

34,461
9
69
95

UNCACHEABLE SUBQUERY

1 Answers1