If your dB consists of many list fields and if these lists go beyond 100 entries … yes
If you want to go up the ladder from a third level up via parent objects that have many list fields … yes
Consider exploring the following resource (paid) that explains this and other aspects about how to build for performance: