Configuration / System / Magento Admin

General

Omit Disabled Products / Categories / Stores	URL's of "Disabled" or "Not Visible Individually" products or inactive categories / stores will not be added to "core_url_rewrite" table during next reindex.	[GLOBAL]
Unique URL Key Verification	Enable instant URL Key verification while editing products.	[GLOBAL]

Clearing Settings of "core_url_rewrite" Table

Now Records in Table	677	[GLOBAL]
Clearing Mode		[GLOBAL]
Qty of Latest Redirects to Keep		[GLOBAL]
Remove Ending with Digit only	Example: [url_key]-123.html	[GLOBAL]
One-Time Removal Limit		[GLOBAL]
Clear Excess Records	It is recommended to run reindex: System->Index Management->Catalog URL Rewrites->Reindex Data once final clearing has been performed. Or click on Reindex button below.
Enable Cleaning by Cron		[GLOBAL]
Start Time	: :	[GLOBAL]
Frequency		[GLOBAL]
Reindex "Catalog URL Rewrites"	Or SSH: "php shell/indexer.php --reindex catalog_url"

Restore URLs Ending with a Digit

Can only be done after clearing and reindex. If a URL is not reserved, it will be used, e.g. [url_key]-123.html > [url_key].html + 301 redirect.

Restore URLs

Routing

Enable Routing of Pages Ending with a Digit	Recommended to turn on routing to avoid 404 after removal of redirects. This enables 301 redirect: [url_key]-123.html [404] > [url_key].html	[GLOBAL]
Enable Routing of Products with Category Path in URL	Performs a 301 redirect: http://example.com/[category_url_key]/[product_url_key].html [404] > http://example.com/[product_url_key].html. Recommended when you disabled the 'Use Categories Path for Product URLs' setting and want to avoid 404 pages from search engines.	[GLOBAL]

Make URLs for Categories and Products Global

Be aware this is an experimental feature suitable not for every store. However it is capable of reducing the size of the "core_url_rewrite" table N times (where N is a number of active store views). Its core is ability to transform URL Keys for categories and products to Global ones, i.e. URL Path of products and categories for all store views would become identical (note this doesn't apply to store code in URL). Existing records with store_id > 0 get removed and new records with store_id = 0 get added from/to the "core_url_rewrite" table respectively. Note, if you run a one store view shop, the setting won't work for you.

Enable Global URL Keys	Once the setting has been altered and saved, admin must perform 1) "Clear URL's", 2) "Reindex" and 3) "Adapt" in order to form the table "core_url_rewrite" correctly.	[GLOBAL]
Clear All System Categories and Products URLs
Reindex "Catalog URL Rewrites"	Or SSH: "php shell/indexer.php --reindex catalog_url"
Adapt the Table's Redirects Records

Additional Information about Log Tables

Green-colored figures indicate a normal state of the tables. Red color warns about increased size of the tables; cron job doesn’t trigger a clearing procedure. Refer to the settings: System > Config > ADVANCED: System > Log.

Table "log_visitor"	0 (total records / the oldest date)
Table "log_url"	0 (total records / the oldest date)
Clear Log Tables	Or SSH: "php -f shell/log.php -- clean --days 180"

Demo Store for URL Rewrites Optimization

Configuration

URL Rewrites Optimization