Krish Munot Krish Munot - 1 year ago 77
SQL Question

This questions has been redacted

This question has been redacted and is no longer valid

Answer Source

Your question is very vague, if you asked the question does an Index take up "extra" space? Then the answer would be ......

No not in the case of a Clustered Index, a clustered index is the actual data stored in a sorted manner.

But on the other hand Non-Clustered Index is a separate structure to the actual table/data itself, containing pointers to the actual data, in this case Yes it would take up extra space .

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download