I have some SQL that completes in ~20 seconds. When I save that SQL as a VDS named CycleTimeLive and then run SELECT * FROM CycleTimeLive, it takes 2 minutes to complete. Each of these queries use the same Reflections. Why would the view SQL run so much faster than selecting from the view itself? I would expect the performance to be similar in each case. This is an urgent issue for me as I have a corp demo of Dremio coming up and I’m trying to get it adopted as a replacement for a current technology.
Attached are the profiles from each run.