However, in terms of insert performance, if the storage subsystem contains many spindles and you’re loading data from multiple sessions, the random order can actually be better than sequential despite the splits.
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Spindles are the "poles" that hold platters in the disk, with each platter being reached by an access arm with a read/write head. More spindles mean data is stored on more platters, meaning it can be accessed simultaneously by more user sessions with less contention (or waiting time between jobs). The same goes for input, random data across spindles can be inserted by more heads and operate faster versus sequential data loading one platter until full.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/56835/