Joomla Database Optimize
You can use export and then import of the Database
or
the option optimize from PHPMYadmin (it is at the center down the bottom, but you have to select the tables by clicking a small box, then you select all the page tables)
or
by using an extension that performs the task like
MSc Software Systems Technology (1991) BSc BA CIS (1989) Solaris 10 Admin 1 (2008) OCA DBA 11g (2011) Bio info: I started with WP in 2017, at the age of 55. I made this site in order to help others to learn it. My Web interests are WordPress, Joomla, Drupal, CodeIgniter, Gimp and, Moodle. I have worked as an Oracle...