I have a layer in SDE Feature Class that I need to expand the text length.
I currently have 600 but I need to expand it to 1500.
According to ArcGIS Help 10.1 I can expand it to 2,147,483,647.
I am afraid that it will slow down the database and webservice.
I was wondering if anyone has field lengths 1000 or bigger and how your database handles it.
Thanks
Are you in Oracle or SQL Server? What version?
SQL Server version 2012
Hey Rickey could you keep the field length at a shortened name, and then add the long name as an alias? I do not know if this would have an effect on the performance as well. In earlier versions of geodatabases we were limited to the number of charters in field names, and this was a way to get around that limitation. I am not sure if the database would look at the alias differently from the actual name. Thank you.