Overview and comparison of advantageousness of database objects for storing in ORACLE database system

This bachelor thesis studies types of tables in ORACLE database system. Main goal of this work is to explain rules and logic of these types, to try their creation and usage and to compare ORACLE company recommendations with the results of these tests. The work is divided into two main parts. The first part tries to explain the possibilities of types of tables in ORACLE database, their advantages and disadvantages, and roughly explain indexes in database, that hang with tables together, to a user who never created any other type of table than standard one. The second part is practical testing of creating those described types of tables, filling them with testing data and comparing results achieved by standard heap organized table with results achieved by other specific type of table