execution plan

hey guys,
What comes to your mind if you see a 80% table scan and 1700 estimated cost in update when your clause is like this?
where auxid >= 1000
but if it is like this,
where auxid = 1000
estimated cost on update is 1.15
Any help would be greatly appreciated.
Thanks,
Neil
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Modification is driven by index on that column and you should check estimated rows vs actual rows
for that search criteria.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil Camara" <neil-on-sql@.restricted.dyndns.org> wrote in message
news:eraBnGdcFHA.3204@.TK2MSFTNGP12.phx.gbl...
> hey guys,
> What comes to your mind if you see a 80% table scan and 1700 estimated cost in update when your
> clause is like this?
> where auxid >= 1000
>
> but if it is like this,
> where auxid = 1000
> estimated cost on update is 1.15
> Any help would be greatly appreciated.
> Thanks,
> Neil
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

execution plan

hey guys,
What comes to your mind if you see a 80% table scan and 1700 estimated cost in update when your clause is like this?
where auxid >= 1000
but if it is like this,
where auxid = 1000
estimated cost on update is 1.15
Any help would be greatly appreciated.
Thanks,
Neil
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...Modification is driven by index on that column and you should check estimated rows vs actual rows
for that search criteria.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil Camara" <neil-on-sql@.restricted.dyndns.org> wrote in message
news:eraBnGdcFHA.3204@.TK2MSFTNGP12.phx.gbl...
> hey guys,
> What comes to your mind if you see a 80% table scan and 1700 estimated cost in update when your
> clause is like this?
> where auxid >= 1000
>
> but if it is like this,
> where auxid = 1000
> estimated cost on update is 1.15
> Any help would be greatly appreciated.
> Thanks,
> Neil
> **********************************************************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

execution plan

hey guys,
What comes to your mind if you see a 80% table scan and 1700 estimated cost
in update when your clause is like this?
where auxid >= 1000
but if it is like this,
where auxid = 1000
estimated cost on update is 1.15
Any help would be greatly appreciated.
Thanks,
Neil
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...Modification is driven by index on that column and you should check estimate
d rows vs actual rows
for that search criteria.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil Camara" <neil-on-sql@.restricted.dyndns.org> wrote in message
news:eraBnGdcFHA.3204@.TK2MSFTNGP12.phx.gbl...
> hey guys,
> What comes to your mind if you see a 80% table scan and 1700 estimated cos
t in update when your
> clause is like this?
> where auxid >= 1000
>
> but if it is like this,
> where auxid = 1000
> estimated cost on update is 1.15
> Any help would be greatly appreciated.
> Thanks,
> Neil
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resour
ces...