Dropping an Index
Query:
Let’s drop an index called index_sale_quantity that we have created above.
DROP INDEX index_sale_quantity ON sales;
Output:
Explanation:
- If the composite index is no longer required or needs any changes.
- It can be dropped using the DROP INDEX statement.
Creating an index in MariaDB
MariaDB is an open–source and database management system. MariaDB is used for several purposes like as data warehousing, e-commerce, and logging applications. MariaDB is faster than MySQL in the replication and querying process. MariaDB supports invisible columns and temporary table space.
In this article, We will understand Creating an Index, the need for Indexing and creating various indexes for understanding, and so on.
It is useful to understand the MariaDB CREATE INDEX command. This boosts the speed of queries and makes databases work better, it increases query speed and improves database function.
Contact Us