How should I (re) index the table while keeping the transaction log small? I have a 170 GB table in a database. It has 70% fragmentation on its index (index has multiple columns in it). The last time I tried DBCC REINDEX the transaction log blew up in the hundreds of GBs.


Should I drop the index and recreate it or do a DBCC REINDEX?   
What is the best way to do either one?   
How can I do either one while keeping the transaction log as small as possible?
DBCC REINDEX is minimally logged in the SIMPLE or BULK_LOGGED recovery model.  If the database is currently in the FULL recovery model, consider toggling it to BULK_LOGGED for the index maintenance.

See http://technet.microsoft.com/en-us/library/ms191484(v=sql.105).aspx