S,F,I numbers as related to business table

Question

Hi All,

I need to check some indices on some tables in SQL server SDE.  I have the S number for the table that needs to be reindexed, however, I can't find the magic decoder ring for determining the business table name in order to perform the reindex.

I know that the table number in the sde.table_registry gives me the adds and deletes tables, but my experience in the past was that the s, f, and i table numbers weren't the same as the adds and deletes.

Can someone point me in the right direction?

Thanks a bunch!

Lorinda

soofigadgets · Answer

@LorindaGilbert wrote:Hi All,

I need to check some indices on some tables in SQL server SDE.  I have the S number for the table that needs to be reindexed, however, I can't find the magic decoder ring for determining the business table name in order to perform the reindex.

I know that the table number in the sde.table_registry gives me the adds and deletes tables, but my experience in the past was that the s, f, and i table numbers weren't the same as the adds and deletes.

Can someone point me in the right direction?

Thanks a bunch!

Lorinda

In the context of ArcSDE (Spatial Database Engine), S, F, and I numbers are identifiers associated with different types of tables:

* S Number: Represents the state tables, storing the current state of spatial data.

* F Number: Signifies the adds and deletes tables, keeping track of changes made to the spatial data.

* I Number: Corresponds to the spatial index tables, which optimize spatial queries for faster retrieval.

These numbers are crucial in managing spatial data within the geodatabase, allowing for efficient tracking of changes and optimization of spatial queries. The relationship to a business table is established through the Registration_ID in the SDE.TABLE_REGISTRY, connecting the S, F, and I tables to their associated business table.

soofigadgets · Answer

In the context of ArcSDE (Spatial Database Engine), S, F, and I numbers are identifiers associated with different types of tables:

* S Number: Represents the state tables, storing the current state of spatial data.

* F Number: Signifies the adds and deletes tables, keeping track of changes made to the spatial data.

* I Number: Corresponds to the spatial index tables, which optimize spatial queries for faster retrieval.

These numbers are crucial in managing spatial data within the geodatabase, allowing for efficient tracking of changes and optimization of spatial queries. The relationship to a business table is established through the Registration_ID in the SDE.TABLE_REGISTRY, connecting the S, F, and I tables to their associated business table.

soofigadgets · Answer

@LorindaGilbert wrote:
Hi All,I need to check some indices on some tables in SQL server SDE.  I have the S number for the table that needs to be reindexed, however, I can't find the magic decoder ring for determining the business table name in order to perform the reindex.

I know that the table number in the sde.table_registry gives me the adds and deletes tables, but my experience in the past was that the s, f, and i table numbers weren't the same as the adds and deletes.

Can someone point me in the right direction?

Thanks a bunch!

Lorinda

To find the business table name associated with the S number in SQL Server SDE, you can check the SDE.TABLE_REGISTRY. While the S, F, and I table numbers might not directly correspond to adds and deletes, the SDE.TABLE_REGISTRY should contain information about the relationships between these tables.

You can query the SDE.TABLE_REGISTRY using the S number to find the associated business table name. Here's an example query:

sqlCopy codeSELECT TABLE_NAME FROM SDE.TABLE_REGISTRY WHERE REGISTRATION_ID = 'YourSNumber';

Replace 'YourSNumber' with the actual S number you have. This should provide you with the business table name associated with the given S number, helping you perform the reindex on the correct table.

Best of luck!