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

• Next in forum: Re: How to find first not null value in column
• Prev in forum: Getting the database name in Server-Side trace event
• Thread view: Re: How to find first not null value in column

[Reply to this message]