In general, indexing refers to the organization of data according to a specific schema or plan. For example, B-tree is the most commonly used data structure for indexing. Because of their low time complexity, search, delete, and insert operations can be done in logarithmic time. An index is a data structure and uses to increase the speed of searching in the database. Indexes will bring many benefits to our databases. For example, an index helps to speed up SELECT queries and WHERE clauses and so on. Moreover, an index could not impact on the data. Creating an index involves creating index statement, which allows naming the index, to indicate the index is in an ascending or descending order something like that.