>>Cross join?
>
>Yes, but, what does this recommand as far as the adjustment? It is not clear what SQL Server exepects to be enhanced as far as helping it to find a better execution plan.
Most likely it just indicates a problem. Was it intentional CROSS JOIN?
If it's not broken, fix it until it is.
My Blog 
