A Data Engineer is evaluating the performance of a query in a development environment. Based on the Query Profile, what are some performance tuning options the Engineer can use? (Choose two.)
A.
Add a LIMIT to the ORDER BY if possible
B.
Use a multi-cluster virtual warehouse with the scaling policy set to standard
Snowflake don't support the create of index, You can cluster a table by a cluster key, but this option is not in the list of option. in addition to this in the question is write that You are in DEV environment. So You don't need to have all the data but to know how SF process them.
there are no indexes in snowflake. And also based on context looks like dev just run this query in some kind of query editor and in such case obviously do not need to return gigabytes of data.
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.
BigDataBB
10 months, 4 weeks agoEshkin_Kot
11 months, 2 weeks agomns0173
8 months, 3 weeks agostopthisnow
1 year ago