4 ms·
As far as I know, database often does query caching. So it doesn't have to recompile the query all the time. On the other hand, query plan may depend on the sp
by lambdaxyzw 2y ago
As far as I know, database often does query caching. So it doesn't have to recompile the query all the time.
On the other hand, query plan may depend on the specific parameters - the engine may produce a different plan for a query for users with deleted=true (index scan) and for deleted=false (99% of users are not deleted, not worth it to use index).