• Geekstone
    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ć


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.



      -   The difference between index and key,

      -   The key design considerations,

      -   The index design considerations.




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.

  • Danila Kiša 3v
    21000 Novi Sad

  • +381(69)701 456

About Us

Geekstone is a non-profit organization dedicated to gathering developers with an aim to facilitate the exchange of knowledge, experiences and ideas related to programming. Moreover, Geekstone is a place for networking and socializing.

Read more
© Geekstone 2015. All rights reserved.
Geekstone © Geekstone 2015. All rights reserved.