|
-
I am doing a table and index reorg using this procedure
1. Export the table data
2. Drop the indexes
3. Truncate the tables
4. Import the data
5. rebuild/re-create the indexes
Is truncating the table enough or do I need to drop and re-create the table.
Can anyone suggest me of a more efficient way of doing this.
Thx
Ed
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|