Magento Sales Flat Quote clean-up Query

gistfile1.txt

#Fit the Number of interval days to your customer requirements. 
#for Magento 1.X CE
  DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);

#for Magento 1.X EE
 DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);
 DELETE FROM enterprise_customer_sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 60 DAY);

#alternative use https://github.com/fbrnc/Aoe_QuoteCleaner