Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Should You Use an Index?
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
The video tutorial discusses two main considerations for using an index: the size of the subset and the frequency of use. For large datasets, creating an index is beneficial if the subset needed is up to 15-20% of the total data. Beyond this, performance may degrade. Additionally, frequent use of an index makes it more cost-effective in terms of computing resources.
Read more
2 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What happens to performance if the subset size exceeds 20%?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
Why is the frequency of use an important consideration for creating an index?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
