sql - Query execution plan of same queries -
observation:
i executing same query through .net code using cmd.executenonquery()
, directly in sql server management studio passing parameter values.
when execute through code runs long time (15-20min) whereas when execute in sql server same parameters completes within few seconds.
the reason taking longer time performance issue of query , solved introduction of non-clustered indexes in 1 of tables.
i still wonder, why taking few seconds earlier sql server although environmental conditions same. due difference in execution plan? idea?
Comments
Post a Comment