Krish Munot Krish Munot - 1 year ago 197
SQL Question

Does an index take space in the disk?

I am curious to know if an index in a database which is valid and used take up space in the disk or not.

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