This UG-evening will start with an introduction of the basics of index design (the heap,clustered/non clustered indexes and covering of a query by an index). Later we will discuss how the optimizer works, why it can be wrong (statistics, procedure cache) and how to correct this. Another part of the session will be some advanced features of indexing like partitioning, locking and  filtered indexes. We will of course not forget indexed views and computed column indexes. If there is some time left we can also look at spatial indexes and xml indexes

Marc Mertens is trainer at Global Knowledge .

Agenda:
18:00 - 18:30 Registration and welcome with a drink & sandwich
18:30 - 20:00 Part 1 of the session
20:00 - 20:30 pause
20:30 - 22:00 Part 2 of the session
22:00 - ... Networking with your peers

This event is sponsored by and takes place in the offices of Global Knowledge in Mechelen. We want to remind that registration is obligatory. You can register here.

Looking forward to see you on January 29th