InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can the rebuilding cluster index rebuild the nonclustered index on the table? |
|
Answer» Each table can have only one Cluster & multiple nonclustered indexes. All nonclustered indexes use index KEY of cluster index or directly depends on the clustered index. Because of this dependency, we usually got this question if REBUILDING the clustered index will rebuild the nonclustered index on a table or not. The answer is NO. Cluster index rebuild will not rebuild or reorganize the nonclustered index. You need to PLAN a nonclustered index rebuild or reorganization separately. |
|