Limitations on view

Sagar Vavhal shared this question 6 years ago
Answered

Hi,


Can you please let me know is there any limit on the number of tables I can have while creating a view for report?

Replies (2)

photo
1

Hi Sagar,


While we do not have a hard number available, and I dont have an excellent setup to test on, my belief is that there is no limit on this. I have personally seen clients with up to 100 tables in a view.

However, adding too many tables should be avoided unless entirely necessary. For both performance, as well as future maintenance and expansion, it is best to keep the view as simple as possible.


Is there a reason why you need so many tables?


Regards,

Nathan

photo
1

Hi Sagar,


I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!


Regards,

Nathan

Leave a Comment
 
Attach a file