====== MariaDB ======

===== Add index to table =====

<code>
ALTER TABLE `users_table` ADD INDEX `ip_index` (`ip_column`)
</code>

Source: [[https://stackoverflow.com/questions/14419090/adding-index-to-column-in-mysql]]