Oracle database - Table Partitioning and Indexing

Oracle Database is a powerful and versatile platform for managing vast amounts of data. While techniques like table partitioning and compression are essential for optimal performance, there’s a wealth of additional knowledge to explore. In this blog post, we’ll discuss a bit on partitioned tables, unpartitioned tables, indexing, and strategies to optimize the performance of an Oracle database. Continue reading Oracle database – Table Partitioning and Indexing

Ubiquitous Database Search in Oracle 23c

The Oracle Database 23c comes with a host of new features and enhancements aimed at making database management more efficient and user-friendly. One standout feature is the introduction of DBMS_SEARCH, a powerful PL/SQL package designed to simplify and optimize indexing for multiple schema objects. Continue reading Ubiquitous Database Search in Oracle 23c