-
Junior Member
index-rebuilding
I have a table in which i have a index for a column,now i delete all the rows
from that table ,then i insert new rows into the same table.Now what will happen to the index of that table,should i rebuild the index in that table.Please suggest me.
-
Re: index-rebuilding
It is strongly recommended to rebuild the index for better performance.
-
Junior Member
Re: index-rebuilding
Thank you for your suggestions,but can u tell me what will happen to that index which was in the table.
-
Re: index-rebuilding
The index will remain there but with new mapping to the addess of data in the column.
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