English

FAQ: Can Oracle partitioning be used by ArcSDE?

Question

Can Oracle partitioning be used by ArcSDE?

Answer

ArcSDE tables using SDEBINARY (Long Raw or BLOB) can be stored as Oracle partitioned tables by entering the partition strings into the appropriate DBTUNE parameters.

However, tests using partitioned SDEBINARY layers have shown that for ArcSDE spatial queries, partitioning the tables does not result in a gain in performance. Therefore, Esri does not recommend partitioning ArcSDE tables for the purpose of achieving better performance.

For additional information on partitioning with ArcSDE 9.2 and st_geometry tables see the Knowledge Base article, "ST_Geometry attributes and Oracle partitioning", located in the Related Information section.

Related Information