<div>
<div class="content wysiwyg-content">
All,<br />
<br />
I have a SQL table that is truncated and repopulated with data nightly. <br />
<br />
The table also has an non-clustered index on the date field.<br />
<br />
When the SQL table is truncated and repopulated with data nightly, does the index need to be reorganized to be effective?
</div>
</div>


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?

SQL Indexes

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.