LOOKUP vs SELECT and efficiency

Hi all - just 2 style/clarification questions about overlapping functionality:

LOOKUP() vs. SELECT() ?

INDEX(SELECT( … ), 1) vs ANY(SELECT( … )) when you’re sure there’s only one result, and it needs to be typecast as its type, not as a returned LIST.

Interested in some guidance both in efficiency and best use cases. Any advice appreciated.

Thx!

1 Like

I’d assume ANY(…) and INDEX(…,1) are equivalent in performance, if that is what you’re asking.

1 Like