SQL geodatabase dbo.i tables?

85
2
Jump to solution
06-09-2022 02:16 PM
Labels (1)
AndreaB
Occasional Contributor III

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.

 

AndreaB_0-1654808952484.png

AndreaB_1-1654809283805.png

 

Thank you,

Andrea

 

0 Kudos
1 Solution

Accepted Solutions
AndreaB
Occasional Contributor III

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 

View solution in original post

0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor

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

0 Kudos
AndreaB
Occasional Contributor III

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 

0 Kudos