Logo

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.

[img]
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.

    Item Type: Article
    Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
    Divisions: Faculty of Industrial Technology > Informatics Engineering Department
    Depositing User: Ibnu Gunawan
    Date Deposited: 16 Aug 2011 17:21
    Last Modified: 16 Aug 2011 17:21
    URI: http://repository.petra.ac.id/id/eprint/15071

    Actions (login required)

    View Item