![]() ![]() Global performance results show that Oracle can improve 7% performance with indexes and PostgreSQL 91%. However, PostgreSQL showed shorter execution times after the optimizations made and proved to be more sensitive. Oracle has shown stability and robustness for queries, with best results in scenarios with poor performance conditions. The results allow inferring a positive impact when using constraints with a significant speedup as well as better throughput. The performance in each set of executions is analyzed. Ten TPC-H queries are performed on tables without any restrictions, with primary and foreign keys and with index constraints. This paper evaluates and compares the performance of Oracle and PostgreSQL database systems with the TPC-H benchmark, following a strategy of adding column-based indexes to optimize query execution. In this context, database optimization is evident as a process of refining database systems, aiming to improve their throughput and performance. Also, current Database Management Systems (DBMSs) need to respond efficiently to operations on their data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |