Post reply

Sargeble?

  • July 29, 2009 at 12:29 pm

    #133519

    What does sargeble mean? How does one make a WHERE clause sargeble? I googled but could not find any info.

  • July 29, 2009 at 12:37 pm

    #1031951

    It's actually SARG able, meaning search arguments can be used by the optimizer to better handle your query.

  • July 29, 2009 at 12:48 pm

    #1031963

    SARG meaning Search ARGument. It refers to a where clause expression that SQL can use as part of an index seek. There are lots of things that could make an expression not SARGable, the main ones are functions applied to the column and leading wildcards.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 29, 2009 at 2:13 pm

    #1032013

    Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply