topic Re: SQL geodatabase dbo.i tables? in Data Management Questions

SQL geodatabase dbo.i tables?

Anonymous User — Thu, 09 Jun 2022 21:16:37 GMT

Hi all,

I'm looking in SQL Server Management Studio. I have a sql geodatabase that is esri version 10.9.1.2.9. I have researched and researched but I can't find the answer - does anyone know what these dbo.i__ tables are and what they are used for? Some kind of ID management.

Thank you,

Andrea

Re: SQL geodatabase dbo.i tables?

VinceAngelo — Fri, 10 Jun 2022 15:44:03 GMT

SEQUENCEs are too slow for bulk-loading data rows. Esri uses "i-tables" to implement the equivalent in batches, with the name using the table_registry identifier as a suffix. They used to be documented, but I can't find where it moved in the current doc set.

- V

Re: SQL geodatabase dbo.i tables?

Anonymous User — Mon, 13 Jun 2022 16:39:14 GMT

For anyone who is also curious my coworker was able to dig out these 2 links that help to explain it:

https://www.e-education.psu.edu/spatialdb/node/2036

https://gis.stackexchange.com/questions/266461/arcgis-sde-i5-i6-i7-tables