Handika, A., Muhammad, M., Azka Bani Shalih, M., Yudha Syahputra, N. and Prayogo Pujiono, I. 2026. QUERY OPTIMIZATION ON SEMI STRUCTURED MYSQL RETAIL DATA USING GENERATED COLUMNS. Jurnal Manajemen Informatika dan Sistem Informasi. 9, 2 (Jun. 2026), 248–259. DOI:https://doi.org/10.36595/misi.v9i2.2058.