core_url_rewrite table should not be truncated unless you understand what you are doing.
magento uses it to keep track of old urls (url_key specifically) and what the new one should be.
if you create a product (or category) and just put in a name like "My Item", magento will add a record to that table that essentially says, 'if the url is "/my-item.html" then show item id 1.
at this point, if you empty that table and then rebuild the indexes, that will work just fine and nothing will not work.
but, let's assume that same "My Item" above. let's say you change the name of that item to "More Specific Item Name", magento will change the url_key for that item to be "more-specific-item-name" and now the records in the core_url_rewrite table will be
for the url "/more-specific-item-name.html" they want to see item 1
for the url "/my-item.html" they want to see item 1
all good, both the old and the new url will work to get to that item. this is good for google or other web crawlers and it is also good for user bookmarks or forum posts, etc that reference the old url directly.
if at this point, you truncate the core_url_rewrite and rebuild the indexes, you'll lose the old url of "/my-item.html" as magento will no longer know what it should show for that url and the visitor (and google or other web crawlers) will get a 404.
to further complicate this, magento, by default, sets the url_key based on the name of the item or category. should you have duplicates, it appends sequential numbers at the end. so, if you have a category called "Pants" and a product called "Pants", then 1 url will be "pants.html" and the other "pants-1.html" magento will only know which one is which by the existing core_url_rewrite data and should you clear out that table, then it could regenerate them in reverse order.
all that said, i make sure i clear out that table before i move a site live because with a lot of product or category name changes will really bloat that table, but once the site is live, i leave it alone unless i have a very good reason.
the other 2 pricing index tables should rebuild exactly the same after you clear them, so no worries on that.