Blog Aggregator - Amardeep Sidhu

  • Tags

  • Archives

  • Meta

  •  

    February 2007
    M T W T F S S
    « Jan   Mar »
     1234
    567891011
    12131415161718
    19202122232425
    262728  

Archive for February 19th, 2007

19 Feb

Access Path Scientific Analysis Part II

We continue to analyze the affects that initialization parameters, statistics and hints have on SQL statement access paths. In this blog, we’ll take a look at the hints we will be using to influence the optimizer to select an access path that is different from the one it would normally choose. We’ll also review a few of the tools that we will be using to monitor and compare SQL statement access paths and performance for our upcoming tests.

© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)

Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette