Post reply

Not getting expected index seek.

  • August 25, 2021 at 6:04 pm

    #3923988

    If you think it will be faster using a seek then just force the query to do a seek and see if it's faster

    select ol.ord_no, pl.ID
      from oeordlin_wv ol
     inner join wsPKGLin pl WITH(FORCESEEK (lnc_ordno_seqno_includes(Ord_no, Seq_no)) )
             ON ol.Ord_no = pl.ord_no
            AND ol.line_seq_no = pl.Seq_no
     where ol.ord_type = 'O'
    option (recompile, maxdop 1)

Viewing post 16 (of 15 total)

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