Table limitation for database view

Rahul RJ
Giga Sage

‎01-30-2019 04:03 AM

Hi Friends,

From how many table we can fetch the data in a database view  (is there any table limitation)

Thanks,

Rahul

Labels:
0 Helpfuls
  • 1,931 Views
1 REPLY 1

asifnoor
Kilo Patron

‎01-30-2019 04:07 AM

Hi RJ,

There is no specific hard limit on the number of tables that you can fetch the data from.

However, As per ServiceNow docs, more the number of tables, the performance of SN will be impacted.

Note: In general, as the number of tables that are included in the view and the number of records that those tables contain increases, the accumulated impact on performance grows. To optimize the performance of the database view ensure that the ‘where’ clauses that are defined in the database view are based on indexed fields.

Ref:https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/concept/c_DatabaseViews.html

Kindly mark the answer as correct if this answers.