Yes, it does have positive effects. After importing the table, its indexes are freshly rebuilt. So in fact it has the same consequences as ALTER INDEX REBUILD, you are just achieving it the hard way .