Comment by soora

In practice, the answer is not always obvious.

Benchmarking multiple queries / approaches is generally worthwhile if performance is important.