'Dba optimizdba' presentation slideshows

mysql and Oracle Optimization

Let us take a simple example. The data stored in a database is in the form of files. Whenever a query is executed to delete data of any form stored in the database, the system deletes the information. But, even after deletion, the file remains with an empty space. This empty space takes up some space in the database. Similarly, when multiple files with empty spaces are left in the system, the database performance is affected.

68 views • 5 slides