Technomedia Journal (TMJ) p-ISSN: 2620-3383 Vol. 8 No. 3 Febuari 2024 e-ISSN: 2528-6544 407 Desi Setiya Budi 1 , Hadi Syahrial 2 Karya ini berlisensi di bawah Creative Commons Attribution 4.0 (CC BY 4.0) Pengoptimalan Performa Database Pada Proses Transformasi Data Pada SQL Server Desi Setiya Budi 1 Hadi Syahrial 2 Universitas Budi Luhur , Jakarta Indonesia E-mail: desisetiyab@gmail.com 1 ; hadi.syahrial@budiluhur.ac.id 2 Setiya Budi, D., & Syahrial, H. . (2023). Optimizing Database Performance in the Data Transformation Process in SQL Server : Pengoptimalan Performa Database Pada Proses Transformasi Data Pada SQL Server. Technomedia Journal, 8(3 Februari), 407–419. https://doi.org/10.33050/tmj.v8i3.2167 ABSTRACT The database itself in general is a collection of data that is stored systematically on a computer that can be processed or manipulated using software (application programs) to produce information. Database definition includes specifications in the form of data types, data structures and also limitations on the data to be stored. One of the tools that are often used is SQL Server. Data processing itself requires a lot of time through various stages. During the data processing stage, there is what is called data transform and data transfer. Which means the data is sent from process A to Process B and changed. In this case it is not information from a data, but what is changed is not the content or value in it, but changes it into a form of information that can be easily accepted and read by readers of the information. In the transform and transfer process, there are several obstacles experienced. What often happens is a matter of time. Time refers to the speed of a data process itself. Because if each process has a very slow speed it will take a lot of time, even though there are many other processes that have to run. In this study, the use of Indexing, Temporary Table techniques and a combination of the two was carried out. In order to get results which are faster to use. In this study using the True Experiment Design method with repeated measurement design. Which in this study will find several treatments, and carried out with more than 1 trial. Keywords: Indexing, Temporary Table, Tuning, True Experiment Design, Database, Optimal, Transformation, Transfer, Data, SQL Server ABSTRAK Database sendiri secara umum adalah kumpulan data yang disimpan secara sistematis di dalam komputer yang dapat diolah atau dimanipulasi menggunakan perangkat lunak (program aplikasi) untuk menghasilkan informasi. Pendefinisian database meliputi spesifikasi