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

Popular posts from this blog

How to show in django cms breadcrumbs full path? -

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -