It definitly can help performance/storage if you periodically add the drop/create index approach to your db maintenance program. The Create Index will grab a lock on the table during operation allowing only reads during duration. So keep that in mind for when you may schedule this since large tables make take awhile.
