Question & Answer
Question
Is there a limit to how many tables I can join or union into a Data Store?
Answer
There is no hard limit to how many tables can be joined or unioned into a data store. However, the more tables you add, the worse the performance of that data store will be. We recommend keeping the number under 20 as once you go over you will see significant negative effects on report performance. If you continue to add sources after 80, admin client performance can degrade considerably.
Applies to: All Versions
[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]
Was this topic helpful?
Document Information
Modified date:
02 November 2020
UID
ibm10781193