4 ms·
> If you are calling multiple views, or worse, views on views on views you are asking the query engine to run multiple queries to return your columns. I though
by racecar789 7y ago
> If you are calling multiple views, or worse, views on views on views you are asking the query engine to run multiple queries to return your columns.
I thought databases flatten all view layers into a single SQL statement before executing. Aka no performance impact except for a couple milliseconds to flatten out the views.
- radiowave 7y agoYes, this was my thought as well. The views being flattened is certainly what I've found it's always looked like was happening, based on the EXPLAIN output.