Posted by Hugo Kornelis on 02/01/06 23:31

On 31 Jan 2006 17:36:03 -0800, Doug wrote:

>SELECT MIN(klugger)
> FROM Foobar
> WHERE klugger IS NOT NULL
>
>
>won't that require a table scan unless there is an index on klugger?

Hi Doug,

Definitely!

--
Hugo Kornelis, SQL Server MVP

[Back to original message]