I think it won't preserve the index but it will recreate the index while running the text sql.