ANALISIS PENGARUH PENGGUNAAN INDEX TERHADAP KINERJA QUERY PADA DATABASE MYSQL

Abstract

To manage large data volumes and high query frequency, modern information systems require fast and effective database performance. One popular optimization method is implementing indexes in databases to improve query performance. This study aims to assess how the use of indexes affects query performance in MySQL. The research includes a literature review and experimental methods. Tests compare the execution time of various query types such as SELECT queries with a WHERE clause, JOIN queries between tables, and ORDER BY queries in indexed and unindexed conditions. The findings indicate that the use of indexes can significantly reduce query execution time, with performance improvements exceeding 90% in all test scenarios. By minimizing full table scans, indexes help speed up data search, integration, and sorting processes. To improve the speed and efficiency of MySQL databases, especially in systems with large data sets and workloads, it is highly recommended to use appropriate indexes on columns frequently used in WHERE, JOIN, and ORDER BY clauses.