Meyliani Tanjung
Unknown Affiliation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

PENGARUH JOIN ORDERING TERHADAP WAKTU RESPON QUERY Meyliani Tanjung; Wasino Wasino; Tony Tony
Jurnal Ilmu Komputer dan Sistem Informasi Vol 1, No 1 (2013): Jurnal Ilmu Komputer dan Sistem Informasi
Publisher : Fakultas Teknologi Informasi Universitas Tarumanagara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24912/jiksi.v1i1.3084

Abstract

The process of retrievingdata in a database is often done in an organization.  In the process, sometimes we need a join query between one relation to another relation. The process of setting up of a join query is very difficult and confusing therefore, this study will present the effect of join ordering and the most optimal way to do join ordering.The study was conductedon AdventureWorksLT Databasee (v2008) Samples RTM (x86)  that has been given additional data using RedGate software. Comparison of the response time is measured through a join query. The results show that the best way to perform a join order is, by joining the large data with the small data first.