January 7, 2022 at 4:15 pm
I have several views that are used for SSRS reports locally and Tableau Reports remotely. The other day after a large update I went to check the reports on Tableau and the updates were not there. I was wondering just as a general question when do views refresh. Is it each time they are accessed or do i need to refresh them after updating the tables.
January 7, 2022 at 4:43 pm
Views (non-indexed) are simply stored query scripts (kind of like a stored procedure w/o parameters) -- the data is selected when the view is queried. Indexed views (relatively rare -- you probably aren't using them) are persisted. The data is updated whenever the underlying tables are updated. Like normal views, the results are selected when the view is queried.
SSRS reports can be cached, but aren't by default.
I know Tableau caches query results, but am not familiar w/ refresh behavior.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply