topic Re: include system tables in ArcGIS Enterprise Questions

include system tables

ErikBlake — Thu, 11 May 2017 16:00:52 GMT

I was wondering if I should be checking the box next to "Include system tables" in the rebuild indexes and analyze dataset tools, after i compress our main editing sde default versioned database. I read the documents on system tables, and the version db admin workflow still not clear on what exactly is the "state" and "state_Lineage" tables. i just want to make sure that if I check the box next to "include system tables" when i do my DB admin task that I am not going to totally mess our tables, data, etc up

Re: include system tables

George_Thompson — Thu, 11 May 2017 16:21:56 GMT

I would include the system tables when running the tool as the enterprise geodatabase administrator (SDE). The tables you reference are involved in the versioned workflows and updating the indexes/statistics may help performance (depending on the number of records in the table and fragmentation). It will not impact the data in the table if you run it.

https://community.esri.com/groups/geodatabase?sr=search&searchId=88a078c5-431b-4dee-b334-4605bfedba6a&searchIndex=0‌

Re: include system tables

ErikBlake — Thu, 11 May 2017 16:24:42 GMT

Cool. Thanks George.

Re: include system tables

JoePlattner — Mon, 16 Sep 2019 19:01:20 GMT

I was wondering the same thing, mostly because "NO_SYSTEM" is the default. If there is no harm or impact to using the "SYSTEM" option, I was curious why "SYSTEM" isn't the default. From George's answer a few years ago it almost sounds like "SYSTEM" is the preferred setting when running this tool

I wonder when it most appropriate to use the "NO_SYSTEM" setting....

This isn't a question anyone needs to answer. I just wanted to add my voice as to why I was confused which setting to use.

I will use the "SYSTEM" option going forward.