METHODS OF HIGH-EFFICIENCY DATA PROCESSING IN ORACLE USING TABLE AND INDEX PARTITIONING

Authors

  • Anastasiia Omelchuk Lesya Ukrainka Volyn National University
  • Anna Yuzva Lesya Ukrainka Volyn National University
  • Lesіa Bulatetska Lesya Ukrainka Volyn National University https://orcid.org/0000-0002-7202-826X

Keywords:

partition, SQL, tablespace, іndex, table, Database

Abstract

Table partitioning in databases is an important method for improving system productivity and reliability. The need for table partitioning is driven by increasing data volumes in the database. Partitioning allows large tables to be divided into smaller, more manageable parts, improving query efficiency, speeding up response times, and simplifying data administration.

References

VLDB and Partitioning Guide. Oracle Help Center. URL: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/vldbg/partition-admin.html#GUID-F2C99CFA-1090-4A62-B452-D4E116A40A34.

Database VLDB and Partitioning Guide - Contents. Moved. URL: https://docs.oracle.com/database/121/VLDBG/toc.htm.

Downloads

Published

2024-06-09

Conference Proceedings Volume

2024: 1st International Scientific and Practical Conference "Problems of Computer Science, Software Modeling and Security of Digital Systems"

Section

Computer science.