To obtain a better yield, it is important:
– increase performance
– to focus on tasks with high added value.

In terms of database engine management, too!

Hence the interest of using dbSQWare…
=> Very flexible, the software adapts to all companies, whatever their size and activity.
=> Thanks to its multiple functionalities, adopting dbSQWare not only means choosing serenity and control, but also making the team of administrators agile and scalable.

To find out more about the dbSQWare software and discover its main functionalities in terms of multi-DBMS operation and maintenance (backup, restoration, copying of environments, reorganization, update statistics, 360° vision), all you have to do is participate in a Discovery webinar.

Led by Lucas HIBOS or Emmy PAYAN from our sales team, it will allow you to discuss in complete confidentiality the management of your database engines, your expectations and the problems encountered.

To register, go to the “Webinaire” tab.

An optimized database improves query performance, reduces processing times and reduces resource consumption (CPU, RAM, Storage, etc.). This is why it is essential to maintain an efficient organization of databases.

Hence the need for reorganization when this is not the case.
This task consists of physically reorganizing indexes and/or tables with the aim of optimizing the use of disk space and improving access to data (through their organization), recovering unused disk space, left by deleted records and/or data updates.

The operation to be carried out depends on the degree of dispersion of the index (or table) information in the database (called fragmentation):
– compaction (REORGANIZE or COMPACT) is often necessary for fragmentation between 10 and 30%
– beyond that, a reconstruction (REBUILD) must be carried out.
A “side effect” of rebuilding a table is rebuilding all of its indexes.

In any case, a successful database is a database that is monitored and maintained.