What Impact Do Indexes Have on Inserts?: Finding All the Red Sweets Part 0

Creating indexes can improve query performance. Oracle must maintain the indexes however. This increases the work it must do whenever you modify data in indexed columns.

In this video Chris looks at this overhead using a real world analogy - recording the color of all the candies stored in party bags!

============================
The Magic of SQL with Chris Saxon

Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

Видео What Impact Do Indexes Have on Inserts?: Finding All the Red Sweets Part 0 канала The Magic of SQL