*the question might not be the exact
In which situation, SELECT is more efficient than IF/THEN ELSE?
A. In the small amount selected data which is randomly distributed for
numeric variables.
B. In the small amount selected data which is uniformly distributed for
numeric variables.
C. In the large amount selected data which is randomly distributed for
character variables.
D. In the large amount selected data which is uniformly distributed for
character variables.
Thanks