Clustered Index Scan Operator has like a warning sign

When i did a "Display Execution Plan", I noticed there was a yellow
triangular sign with an exclamation mark for the Clustered Index Scan
Operator. Why is that so ?
So this is what i see
select * from table1 where date1 = '2007-11-10 11:00' -- This query shows a
clustered Index Scan operator without the warning sign
select * from table1 where date1 > '2007-11-10 11:00' -- This query shows a
clustered Index Scan operator with the warning sign
Do I need to do something to make the warning sign go ?Try updating statistics.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:%23jhqgDOSIHA.5264@.TK2MSFTNGP02.phx.gbl...
> When i did a "Display Execution Plan", I noticed there was a yellow
> triangular sign with an exclamation mark for the Clustered Index Scan
> Operator. Why is that so ?
> So this is what i see
> select * from table1 where date1 = '2007-11-10 11:00' -- This query shows
> a clustered Index Scan operator without the warning sign
> select * from table1 where date1 > '2007-11-10 11:00' -- This query shows
> a clustered Index Scan operator with the warning sign
> Do I need to do something to make the warning sign go ?|||Hi Hassan,
If you hover the mouse cursor over the node with the warning, it should
display an explanation of the warning. Your two queries both look fine - it
will depend on what the actual warning is.
Cheers,
Jim
"Hassan" <hassan@.test.com> wrote in message
news:%23jhqgDOSIHA.5264@.TK2MSFTNGP02.phx.gbl...
> When i did a "Display Execution Plan", I noticed there was a yellow
> triangular sign with an exclamation mark for the Clustered Index Scan
> Operator. Why is that so ?
> So this is what i see
> select * from table1 where date1 = '2007-11-10 11:00' -- This query shows
> a clustered Index Scan operator without the warning sign
> select * from table1 where date1 > '2007-11-10 11:00' -- This query shows
> a clustered Index Scan operator with the warning sign
> Do I need to do something to make the warning sign go ?