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