We have recently migrated Magento1 to Magento2.we found that url_rewrite table has almost 16000000+ rows. M1 site was build before 6 years and the url rewrite table has increased over the years. This website has around 6000+ categories and 8000+ products.
Is there a good article or process that we can optimize this table to increase the performance. We want to make sure we do not lose any SEO URLs.