title: Very large index on 2 billion unique rows
body: <p>I have a table that has over 2 billion rows. The clustered index on it consists of almost all of the fields due to the unique nature of the data. The data is also updated daily. The index is larger than the database (300GB vs almost 800GB) Is an index that size even worth the amount of space it is taking based on speed?</p>