any way to reduce the # of executions of the index seek on object28.index25?

a recent upgrade of the software has caused reduced performance -one table, object28, goes from being scanned once, with 3k logical reads, to being scanned 46 million times with 148million logical reads. this is the same code, with just version differences of IC.

the index seek on object28.index25 gets executed

the indexes on the two tables involved haven't changed that i can see.

any ideas much appreciated, i am stuck on what to try/recommend.

avatar image By michael albert 0 asked Sep 14, 2017 at 02:24 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: Sep 14, 2017 at 02:24 PM

Seen: 34 times

Last Updated: Sep 14, 2017 at 02:24 PM