topic Creating Attribute Index - UNIQUE, ASCENDING in Data Management Questions https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416822#M23792 <HTML><HEAD></HEAD><BODY><SPAN>I am having problems creating an attribute index on file geodatabase tables that are UNIQUE and ASCENDING.</SPAN><BR /><BR /><SPAN>The FGDB tables contains data that originated from an ArcSDE-SQL Server database. It had indexes on the primary key fields (all character) that according to the table properties dialog in ArcCatalog are all UNIQUE and sorted in ASCENDING order.</SPAN><BR /><BR /><SPAN>After copying some of the data to new tables in a file geodatabase, I have been unable to duplicate the indexes in the file geodatabase. I have tried this under 9.3.1 and 10.0 with the same results. I have tried this through ArcToolbox, through the table properties/indexes dialog and through scripting. I've tried it with several different tables and file geodatabases. No error messages, but the resulting indexes always ends up being </SPAN><STRONG>NON_UNIQUE</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>I thought perhaps there was a problem with creating unique indexes on a character or text field, so I tried creating a new field (LONG) and calculating it equal to the OBJECTID. I wasn't able to create a UNIQUE index on that field either.</SPAN><BR /><BR /><SPAN>The last thing I tested was using a personal geodatabase and guess what, it works fine. The only problem is that I can't use a personal geodatabase because of size limitations.</SPAN><BR /><BR /><SPAN>Any suggestions? Am I worrying about nothing? It seems that with a large database it would be important to have the correct type of index.</SPAN><BR /><BR /><SPAN>-Steve</SPAN></BODY></HTML> Thu, 27 Sep 2012 15:39:16 GMT StevePeaslee 2012-09-27T15:39:16Z Creating Attribute Index - UNIQUE, ASCENDING https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416822#M23792 <HTML><HEAD></HEAD><BODY><SPAN>I am having problems creating an attribute index on file geodatabase tables that are UNIQUE and ASCENDING.</SPAN><BR /><BR /><SPAN>The FGDB tables contains data that originated from an ArcSDE-SQL Server database. It had indexes on the primary key fields (all character) that according to the table properties dialog in ArcCatalog are all UNIQUE and sorted in ASCENDING order.</SPAN><BR /><BR /><SPAN>After copying some of the data to new tables in a file geodatabase, I have been unable to duplicate the indexes in the file geodatabase. I have tried this under 9.3.1 and 10.0 with the same results. I have tried this through ArcToolbox, through the table properties/indexes dialog and through scripting. I've tried it with several different tables and file geodatabases. No error messages, but the resulting indexes always ends up being </SPAN><STRONG>NON_UNIQUE</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>I thought perhaps there was a problem with creating unique indexes on a character or text field, so I tried creating a new field (LONG) and calculating it equal to the OBJECTID. I wasn't able to create a UNIQUE index on that field either.</SPAN><BR /><BR /><SPAN>The last thing I tested was using a personal geodatabase and guess what, it works fine. The only problem is that I can't use a personal geodatabase because of size limitations.</SPAN><BR /><BR /><SPAN>Any suggestions? Am I worrying about nothing? It seems that with a large database it would be important to have the correct type of index.</SPAN><BR /><BR /><SPAN>-Steve</SPAN></BODY></HTML> Thu, 27 Sep 2012 15:39:16 GMT https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416822#M23792 StevePeaslee 2012-09-27T15:39:16Z Re: Creating Attribute Index - UNIQUE, ASCENDING https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416823#M23793 <HTML><HEAD></HEAD><BODY><SPAN>Hi Steve,</SPAN><BR /><BR /><SPAN>Unique indexes are not supported on File Geodatabases.&nbsp; See the section Unique Indexes </SPAN><A class="jive-link-external-small" href="http://resources.arcgis.com/en/help/main/10.1/index.html#//005s00000011000000" rel="nofollow" target="_blank">here</A><SPAN>.</SPAN></BODY></HTML> Thu, 27 Sep 2012 16:00:27 GMT https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416823#M23793 JakeSkinner 2012-09-27T16:00:27Z Re: Creating Attribute Index - UNIQUE, ASCENDING https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416824#M23794 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Jake. MyBad for not looking a little harder. The AddIndex_management tool documentation doesn't mention any of those restrictions and in fact uses a file geodatabase in their example code.</SPAN><BR /><BR /><SPAN>-Steve</SPAN></BODY></HTML> Fri, 28 Sep 2012 11:36:33 GMT https://community.esri.com/t5/data-management-questions/creating-attribute-index-unique-ascending/m-p/416824#M23794 StevePeaslee 2012-09-28T11:36:33Z