Dropping KEYSETs tables ORACLE

297
0
06-12-2022 11:26 PM
yockee
by
Occasional Contributor II

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

0 Kudos
0 Replies