Does anyone know if using the SQL Server Management Studio Index Rebuild, rebuilds the index online or offline?
Reading the help documentation doesn't say anything on this (so I would assume it is offline) but I would like to know, as I prefer using the GUI over Transact SQL.
If the rebuild happens online, then how would I know how long it takes? The Index Rebuild window closes after a few seconds, so is it fair to assume that at this point the rebuild is complete, or is it still going on in the background? There's no indicator of any change