isames
asked on
SQL Indexes
All,
I have a SQL table that is truncated and repopulated with data nightly.
The table also has an non-clustered index on the date field.
When the SQL table is truncated and repopulated with data nightly, does the index need to be reorganized to be effective?
I have a SQL table that is truncated and repopulated with data nightly.
The table also has an non-clustered index on the date field.
When the SQL table is truncated and repopulated with data nightly, does the index need to be reorganized to be effective?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.