Hello,
I have KEYSET tables around 30K tables and I am preparing to delete them all. Currently, I used scheduled job that drops some 1000 tables that runs once at midnite.
Some curiosities :
1. What cause the formation of these tables ? One cause is that it is needed when joining tables with > 100 records match.
2. Does a process from Map / Feature Service create these tables too ? Say there is a map service that join 2 tables with more than 100 records match. Do this create KEYSET table ?
3. If I drop all of them, will it have any adverse effect on the whole workflow / infrastructure. Will the geodb still be accessible ? Will map services (if it has any effect on map services) still working properly ? I have seen some some readings telling that dropping all Keysets are just fine. I have also follow the instruction on Dropping keyset given by Esri.
Many thanks
