My SAS Tutorials

Wednesday 24 October 2012

Index Q2

For Compound Index optimization to occur which statement is false:

a>
It works even when the key variables are not mentioned in the WHERE condition.
b>
At least the first two key variables in the composite index must be used in the WHERE conditions.
c>
The condition must be connected using the AND operator
d>
At least one condition must use the EQ,equal sign(=) or IN operator.

If you know the answer then comment: 

If you want to Learn Base SAS and Advance SAS please mail me at creativityofnature@gmail.com.

Index Q1

1>Which is false regarding index usage?

a>
A comparison operator or the IN operator.
b>
The NOT operator.
c>
We can use indexes with Sounds like operator.
d>
The TRIM or SUBSTR functions (provided the second argument of the SUBSTR function is 1)

Which option is True and why?

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com



For training related info kindly mail us at info@sankhyana.com
Sankhyana Consultancy Services
www.sankhyana.com