Unique Indexes in ArcSDE for Oracle 11g and Registering as Versioned

528
4
Jump to solution
03-07-2013 10:10 AM
Occasional Contributor
I am using ArcGIS 10.1 SP1 and I have been trying to devise an indexing strategy for our new geodatabase.  When implementing it, I am having problems making unique indexes and registering as versioned.  Whichever order I use doesn't make a difference, the second tool won't allow unique indexes and registering as versioned.

I saw an older 9.3 article on this and it said you could do both if you register as versioned first, then create your unique indexes.  That hasn't worked for me.  Also, the ArcGIS 10 help said it doesn't recommend using unique indexes because of the potential for compress problems.

Is it  a good idea to skip unique indexes and use Data Reviewer to check uniqueness later?  I thought it would make sense to enforce uniqueness where it should apply.

Thanks,


Nathan
Reply
0 Kudos
1 Solution

Accepted Solutions
New Contributor II
'Unique indexes can't be specified for multiversion tables" - this is by design. 

By the same design, with a table registered as versioned, the option to make the attribute index unique is grayed out in the 'Add Attribute Index' tool.

http://support.esri.com/en/knowledgebase/techarticles/detail/25580

View solution in original post

Reply
0 Kudos
4 Replies
Esri Esteemed Contributor
There's two problems with unique indexes on versioned data:
1) The new data is added to the Adds table, so the integrity constraint wouldn't
occur when needed
2) It's perfectly valid to have multiple unique values in the Adds table, so long
as only one of them is eventually posted to the business table.

There's also a performance cost associated with unique indexes in general, so if
you're not going to see a benefit from that cost, why pay it?

- V
Reply
0 Kudos
Occasional Contributor
Thanks for that explanation.  Do you think the article I saw was probably referring to manually building unique indexes on just the base tables?  I couldn't build any unique indexes after versioning with the GP tools.
Reply
0 Kudos
Esri Esteemed Contributor
Where "manually" is "outside the ken of ArcGIS"? Yes.

- V
Reply
0 Kudos
New Contributor II
'Unique indexes can't be specified for multiversion tables" - this is by design. 

By the same design, with a table registered as versioned, the option to make the attribute index unique is grayed out in the 'Add Attribute Index' tool.

http://support.esri.com/en/knowledgebase/techarticles/detail/25580

View solution in original post

Reply
0 Kudos