"The query consumes a lot of resources. Typically, this means that the query consumes a lot of processing time or credits, but it could also mean that the query consumes a lot of storage space for intermediate results."
This is why it is not D
B and D is the right answer
Create a materialized view when all of the following are true:
The query results from the view don’t change often. This almost always means that the underlying/base table for the view doesn’t change often, or at least that the subset of base table rows used in the materialized view don’t change often.
The results of the view are used often (typically significantly more often than the query results change).
The query consumes a lot of resources. Typically, this means that the query consumes a lot of processing time or credits, but it could also mean that the query consumes a lot of storage space for intermediate results.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
halol
Highly Voted 1Â year, 11Â months ago_yyukta
Most Recent 8Â months, 2Â weeks agoMultiCloudIronMan
1Â year, 3Â months agoHarpreetwal
1Â year, 6Â months agocgapperi
1Â year, 8Â months agoyogendrat52
1Â year, 9Â months agokokosz
1Â year, 10Â months ago