3 ms·
> Also remember indexes take space Indexes take space, except for the clustered index. An important distinction. If the point of this table is always selecti
by cogman10 5y ago
> Also remember indexes take space
Indexes take space, except for the clustered index.
An important distinction.
If the point of this table is always selecting based on IP, m_from, m_to, then clustering on those columns in that order would make sense.
Of course, if it's expected that a lot of other query patterns will exist then it might make sense to only cluster on one of those columns and build indexes on the others.