title: MS SQL query hint FAST for read XML
body: <p>I have followed code in my stored procedure:</p>
  
  <pre><code>    SELECT
          ID,
          &lt;..some other columns&gt;
      INTO #MyTable
      FROM OPENXML(@hXML, N'/Root//Element', 2)
      WITH (
          ID int,
          &lt;..some other columns with types&gt;)
  </code></pre>
  
  <p>When I checked execution plan I found that:</p>
  
  <ol>
  <li>Estimated Cost 77,5%</li>
  <li>Estimatd Rows 10 000</li>
  <li>Estimated IO Cost 78,7%</li>
  </ol>
  
  <p>My xml data usually contains not 2-5 items.
  When I user SQL hint FAST(10) then I can see estimation value near 0.</p>
  
  <p>Should I use this hint? Does it help SQL Server perform query faster in some way?</p>