August 2017
Beginner to intermediate
426 pages
9h 36m
English
By configuring the session properties to use the bulk load, your performance can be significantly enhanced. When you use bulk loading, the database logs are not created; this, in turn, enhances the performance.
However, if you disable the database log, recovery cannot be done as there is no log of the events on the database.
As you can notice, performance can be achieved by compromising on some other factors. You need to decide and make a fine balance between all the factors.
These were the various ways in which you can find and eliminate the target bottleneck. In the next section, we will talk about the source bottleneck.
Read now
Unlock full access