What is the Table Per Partition distinction rule? When the number of physical columns is reached, the partition alias will be generated?

Peter64
Tera Contributor

‎04-12-2022 08:56 PM

What is the Table Per Partition distinction rule? When the number of physical columns is reached, the partition alias will be generated?

0 Helpfuls
  • 752 Views
3 REPLIES 3

Hitoshi Ozawa
Giga Sage
Giga Sage

‎04-12-2022 09:24 PM

Hi Peter,

Seems correct according to the following Now Support page.

  • Table per partition - Creates one database table for the parent class, which stores all records for the parent and child classes. Child classes do not have separate database tables. As the database table reaches a storage limit, the system dynamically adds storage tables (partitions) to store additional records.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0749585

0 Helpfuls

Hitoshi Ozawa
Giga Sage
Giga Sage
In response to Hitoshi Ozawa

‎04-12-2022 09:26 PM

Also check the following Now Support page. TPP (Table Per Partition) is supported in CMDB hierarchy. Task and other tables have different table structure.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0723580

0 Helpfuls

Peter64
Tera Contributor
In response to Hitoshi Ozawa

‎04-18-2022 12:50 AM

serviceNow, at present, how much storage limit is set before dynamically adding storage tables (partitions) to store additional records

0 Helpfuls