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.