https://community.esri.com/t5/arcgis-enterprise-questions/dropping-keysets-tables-oracle/m-p/1182206#M33320 <P>Hello,</P><P>&nbsp;</P><P>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.</P><P>Some curiosities :</P><P>1. What cause the formation of these tables ? One cause is that it is needed when joining tables with &gt; 100 records match.</P><P>2.&nbsp; 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 ?</P><P>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.&nbsp;</P><P>Many thanks</P> Mon, 13 Jun 2022 06:26:56 GMT yockee 2022-06-13T06:26:56Z https://community.esri.com/t5/arcgis-enterprise-questions/dropping-keysets-tables-oracle/m-p/1182206#M33320 <P>Hello,</P><P>&nbsp;</P><P>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.</P><P>Some curiosities :</P><P>1. What cause the formation of these tables ? One cause is that it is needed when joining tables with &gt; 100 records match.</P><P>2.&nbsp; 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 ?</P><P>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.&nbsp;</P><P>Many thanks</P> Mon, 13 Jun 2022 06:26:56 GMT https://community.esri.com/t5/arcgis-enterprise-questions/dropping-keysets-tables-oracle/m-p/1182206#M33320 yockee 2022-06-13T06:26:56Z