Perpustakaan Fakultas Ilmu Komputer

Call Number	SEM - 362
Collection Type	Indeks Artikel prosiding/Sem
Title	Optimization SQL server 2005 wuery using cost model and statistic ( hal 272 - 276)
Author	Ibnu Gunawan;
Publisher	Proceedings ICSIIT 2010: International conference on soft computing intelligent system and information technology 1-2 July 2010 Bali Indonesia
Subject	MS SQL Server, database, statistic, query, optimization
Location

Lokasi : Perpustakaan Fakultas Ilmu Komputer

Nomor Panggil	ID Koleksi	Status
SEM - 362		TERSEDIA

Tidak ada review pada koleksi ini: 47902

MS SQL server query optimizer[1] is an opimization tools that based on a cost model, the database metadata, database statistics, system resources(memory, IO, CPU) and the query itself. if we want to optimize the query in MS SQL server, we must optimize the factor that MS SQL server query optimer rely on. three of that factor is cost model, statistics and the query itself. in SQL Server 2005[2] one tools that can do optimization based on statistic and query is known as DTA. these paper will explain how the query optimizer work, then it will explain how the DTA work side by side with query optimizer and it will explain how to use the DTA to outo optimize the query.