The SQL server database size is 609GB and one of the index (clustered)size is 598 GB and the particular table size is 604GB. whether the index contains data? why the index is this much big?


A clustered index is the table.

Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition. There can be only one clustered index per table, because the data rows themselves can be stored in only one order.

Clustered and Nonclustered Indexes Described

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.