For the below example query, UI (run) will be accelerated but reflection refresh will not be accelerated.
Query profile for UI (run) a833c381-532a-4013-9b7f-04de1eb12106.zip (38.2 KB)
with subscribers as (
select user_profile_id
from "core".subscriptions
)
select *
from "core".signups
inner join subscribers on subscribers.user_profile_id = signups.user_profile_id
The reflection refresh does not look like it’s referring to the same VDS as your query (compare the Convert To Rel sections of the query plan and you’ll see they are different).
For the reflection job, can you try running a SELECT * FROM my.vds where my.vds is the VDS for which you’ve built the reflection?
@joejk, I was mistaken; those Convert To Rel may be different depending on whether you are doing and aggregate reflection or a raw reflection. The information I requested would still be useful in diagnosing the issue.
@ben,
I ran into this again with another query. Posting it hoping it is useful. Also, it would be useful if there is any documentation around what Convert to Rel is.