Suppose I have a table
Stuff with a column
City and no indices including that column. I populate the table. Then I decide to create an index:
CREATE INDEX [StuffOnCityIndex] ON [dbo].[Stuff](City ASC);
and the database confirms that
CREATE INDEX succeeded.
Will the newly created index immediately include all existing entries from the table or will it be slowly built "in background"? In other words, if I think that creating an index will improve performance then will I see that improvement immediately upon
CREATE INDEX completion?