Updating indexes for block
This will use the SQL UPDATE command with the WHERE clause to update the selected data in the My SQL table tutorials_tbl.
The following example will update the tutorial_title field for a record having the tutorial_id as 3.
Specifies all indexes associated with the table or view regardless of the index type.
Specifying ALL causes the statement to fail if one or more indexes are in an offline or read-only filegroup or the specified operation is not allowed on one or more index types.
This allows queries or updates to the underlying table and indexes to continue.
At the start of the operation, a Shared (S) lock is very briefly held on the source object.
For more information, see Specifies the index leaf level will be reorganized. ALTER INDEX REORGANIZE statement is always performed online.
This means long-term blocking table locks are not held and queries or updates to the underlying table can continue during the ALTER INDEX REORGANIZE transaction.
Specifies whether underlying tables and associated indexes are available for queries and data modification during the index operation. For an XML index or spatial index, only ONLINE = OFF is supported, and if ONLINE is set to ON an error is raised.
Disabling a clustered index prevents user access to the underlying table data.
To enable an index, use ALTER INDEX REBUILD or CREATE INDEX WITH DROP_EXISTING.
Long-term table locks are not held for the duration of the index operation.
During the main phase of the index operation, only an Intent Share (IS) lock is held on the source table.The rebuild operation can be minimally logged if the database recovery model is set to either bulk-logged or simple.