Maesaroh, Siti and Gunawan, Heru and Lestari, Agung and Tsaurie, Muhammad Sufyan Ats (2022) Query Optimization In MySQL Database Using Index. International Journal of Cyber and IT Service Management (IJCITSM), 2 (2). pp. 1-7. ISSN 2808-554X

Text v2-n2-02.pdf - Published Version Restricted to Registered users only Download (410kB)

Abstract

The quality of a database design has a significant impact on the quality of an information system. Even if a system has been running for a long time, a programmer may forget to optimize a query in MySQL, even though optimization is critical as the amount of data is enormous. MySQL has an index function for tables that helps to speed up database searches. In essence, the index will be beneficial if utilized by the user's interests and wants; otherwise, the index, constructed randomly and in large quantities, would slow down database access. As a result, before constructing a database index, it is necessary to reconsider the rules and conduct a thorough examination.

Actions (login required)

View Item