Optimization SQL Server 2005 Query Using Cost Model and Statistic

gunawan, ibnu Optimization SQL Server 2005 Query Using Cost Model and Statistic. International Conference on Soft Computing, Intelligent System and Information Technology.

Preview

PDF (Optimization SQL Server 2005 Query Using Cost Model and Statistic. ICSIIT 2010) - Published Version Download (221Kb) | Preview

Abstract

MS SQL Server Query Optimizer[1] is an optimization 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 Optimizer 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 auto optimize the query.

Actions (login required)