Is it possible , that .net app uses different executin plan hwile query
analyzer sues different plan?No. At least not that I know of. SQL will execute a query the same if
it's in a stored procedure or in .net code.
Are you using System.Data.SqlClient data objects OR System.Data.Oledb
data objects? That would make a small difference in performance.
Also if you write your selects, updates, inserts and deletes in a
stored procedure it will execute faster (than in .net code) because the
execution plan is cached in SQL.
VSS wrote:
> Is it possible , that .net app uses different executin plan hwile query
> analyzer sues different plan?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment