Proper indexing is a very time and cost-effective way to improve performance. Yet it is often done in a very sloppy way. This talk explains the organizational misconceptions that lead to sloppy indexing and gives advice how to change it. Finally we will show the results of a short online quiz that reveals the state of indexing know-how in the field.
Watch this video on http://oredev.org/2013/wed-fri-conference/lightning-fast-sql-with-proper-indexing