that heavily depends on your game.
Godot allready uses a binary tree to optimize collision tests. So a collsion calculation only occurs when objects are near echother.
My guess would be that a script wouldnt do much of a performance increase in this case.
You can check the impact of the physics on your game in the performance monitor of godot (time->physicsprocess, physics->collisionpairs etc.)