× Focus index and non-focus index

bobopu

Let's talk
When will you build a focused index?
When is an unfocused index suitable?

我是杀人狂

See online help~

wgfxman

Clustered index
When creating a clustered index on a table (heap) or deleting and recreating an existing clustered index, the database is required to have an additional available work area to accommodate the data sorting results and temporary copies of the original table or existing clustered index data.

dream88

The primary key will automatically create a focused index by default
Focused index There is only one table, so it is very valuable.