Share via

Index size is 598GB and database size is 609GB. whether the index contains data?

kumar-9444 121 Reputation points
2020-11-24T15:58:15.713+00:00

The 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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,942 questions
0 comments
Accepted answer
  1. Shashank Singh 6,251 Reputation points
    2020-11-24T16:55:28.597+00:00

    whether the index contains data? why the index is this much big?

    In your case since you are talking about clustered index, this is basically the table itself. So yes clustered index has the data and the index size is the table size, almost

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.