Toward Exhaustive Teaching Of Relational Database Indexes
Massimo Macera, Paolo Rocchi · 2012
There are several indexing techniques that can optimize system performances. The choice of the right index in a relational database can improve the performances by up to 80%. Unfortunately the illustrations of the various techniques are scattered over a number of texts and manuals, and the courses for database designers are often somewhat incomplete. The present paper shows a didactical experience which tackles this kind of limitations. In particular we have prepared a textbook that includes twenty-one different index formats, it discusses advantages and disadvantages of each indexing technique, and has been positively validated during advanced courses on relational database design.