If you are designing databases, meaning creating tables, this session is for you. The session will review the normal primary key, clustered and non-clustered indexes. But the meat of the session will help a developer understand some of the new indexing added over the last decade. These will include indexed views, column store indexes as well as filtered Indexes. Included with these indexes will be an overview of the maintenance that needs to be maintained on indexes as well as statistics. Some changes has been made to the maintenance abilities and there are some specifics that need to be known and learnt.