Forum Replies Created

Viewing 2 posts - 16 through 17 (of 17 total)

  • RE: optimizer "LIKE" vs "="

    sql-plans in attachment ...

    How can I delete this post ... ?

  • RE: optimizer "LIKE" vs "="

    Yes, the index covers both columns - so it SHOULD be used for selection:

    CREATE NONCLUSTERED INDEX [pw_test] ON [dbo].[objkeys]

    (

    [okeyname] ASC,

    [okeydata] ASC,

    [parentid] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Viewing 2 posts - 16 through 17 (of 17 total)