Forum Replies Created

Viewing 4 posts - 16 through 19 (of 19 total)

  • RE: The Cost of Function Use In A Where Clause

    --My Test

    Set NoCount On

    Go

    Create Table #Testing(

    TestingId int identity not null,

    SomeColumn varchar(25) not null

    )

    Go

    Declare @x int

    Set @x = 1000

    While @x > 0

    Begin

    Insert Into #Testing (SomeColumn)

    Select 'John' Union

    Select 'James' Union

    Select 'Mary' Union

    Select...

    February 28, 2008 at 12:24 pm

    #783403

  • RE: The Cost of Function Use In A Where Clause

    Jeff Moden (2/28/2008)

    Yes, they both "utilize" the index... but how? I think you'll find that utilization is limited to an Index SCAN and that you cannot get an Index...

    February 28, 2008 at 12:21 pm

    #783401

  • RE: The Cost of Function Use In A Where Clause

    Nick Rawlins (2/28/2008)

    Good artible, however a full table scan isn't being performed, but an Index Scan is which is different to a table scan...

    There really isnt much of a difference...

    February 28, 2008 at 10:48 am

    #783360

  • RE: The Cost of Function Use In A Where Clause

    I liked the article, but I don't seem to have the problem with my queries that you are describing when using functions like IsNull in the where clause.

    Im...

    February 28, 2008 at 9:55 am

    #783334

Viewing 4 posts - 16 through 19 (of 19 total)