Mostly of tables have a clustered index. In addition, non-clustered indexes also created in need. To improve index performance, some columns may be included to non-clustered index.
At this point it is important that clustered index keys are not included. Because clustered index keys already exists in non-clustered indexes, including clustered index keys to non-clustered is useless. Beside this, it has adverse effect, like index size gets bigger just for nothing.
No comments:
Post a Comment