sql - If I insert rows or update values in an existing row, are those indexes for the updated columns updates at that time? -

or need update them specifically. situation this: have table 1.5 million rows , 90 columns. have done massive amount of cleanup on data , need know if should rebuild indexes or if rebuilt during update , insert operation on table.

there up-to-date. when update or insert (or delete) completes, constraints have been checked, indexes updated , triggers have run ok too. includes indexed views on tables.

this consistency in acid:

statistics not updated until needed (which query compile time) irrelevant