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.

No comments:

Post a Comment