In this video, Jing Wang talks about what database index is, how does it make a query faster and how to create appropriate indexes. Jing provides an introduction to database index and explains the differences between clustered index and non-clustered index. Jing provides examples to show how table data is accessed with index and how does index improves the speed of data retrieval operations. Jing also talks about the downfalls of creating too many indexes and what kind of columns should we consider creating indexes on, so you'll know how to build more useful database indexes.
Project Members: Jing Wang