Answer
Hotspots occur when many inserts hit the same index page (e.g., identity keys). They cause blocking and contention.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ