Designing Indexes and Keys

Meetup
13/04/16 06:02 PM
Designing Indexes and Keys
Duško Mirković

Amphitheater in the mail building University of Novi Sad

free entrance

Ognjen Radovic

Milana Cap

Isidora Škulec

Bojan Buneta

Saša Popović

Dejan Milicic

Marko Anić

Igor Surla

Borislav Lazendić

Topic

Structure of keys and indexes can greatly affect table physical storage and the performance when manipulating its data. Sometimes the choice of indexes is accidental or automatically generated which can severely impact performance and it is usually detected in late phases of the project when it can be expensive to change database schema. This session gives several guidelines that will prevent typical pitfalls and explain why it is important to carefully design indexes and keys.

Topics:

- The difference between index and key,

- The key design considerations,

- The index design considerations.

#Index #Keys #meetup

lecturer

Duško Mirković

Duško is software architect in Schneider Electric DMS NS. If he had another job, software development would be his hobby. For the last 7 years he spent most of the time developing databases and data access layer for SQL Server, historical databases, data warehouses as well as database development process. Broad foundation in object oriented programming helps him to more efficiently bridge the gap between object and relational model. He believes that one can only be strong as much as the people around him, which gives him motivation to share. When he shuts down the computer he likes to spend time with his family and friends or read epic fantasy and science fiction.