Q: 9
Which cache type is used to cache data output from SQL queries?
Options
Discussion
Maybe B, result cache. Metadata cache trips people up but it’s not for actual SQL output. If I’m off let me know.
B pretty sure, result cache is the one that stores query outputs. Someone confirm if that's right?
A is wrong, B. Only result cache actually holds the SQL output.
B is right, result cache holds SQL query outputs so you get faster response if you run the same query again. Not 100% sure about edge cases, but that's what I've seen in practice. Correct me if there's a catch.
Be respectful. No spam.
