Impact of Bind Variables on SQL Performance

added by JavaScript Kicks
7/30/2018 7:38:00 AM

701 Views

Use of bind variable can speed up the execution plan up to 2.5 times as compared to those that do not use execution plan. For trivial queries, such performances matter a lot, while for the complex queries it can be a bit less, as in complex queries execution itself takes a lot of time.


0 comments