15.15.3. Creating Index Keys
As part of every table-write operation
DELETE), the storage engine is required to
update its internal index information.
The method used to update indexes will vary from storage engine
to storage engine, depending on the method used to store the
In general, the storage engine will have to use row information
passed in functions such as
in combination with index information for the table to determine
what index data needs to be modified, and make the needed
The method of associating an index with its row will depend on
your storage approach. The
engine stores the primary key of the row in the index while
other storage engines often store the row offset.