Sorry for late reply because of XMas 😉

Merry XMas to you all

The index on Arueck is only a clustered index on fr_id, which is needed (i think) for the second...

Now here is the actual execution plan from the DEV Server.

I was wrong, execution is fast as expected

Thanks again for your kind support

Chris

ok, i will post it but ... tomorrow .. hold on

and thank you

Chris

Ok, it works ...

i had the chance to get a copy of the DB on a DEV Server. I took a clustered index on fz_senddat as you advised, and now...

Thank you Ninja,

i should try to dig deeper in analyzing execution plans 🙂

Did you mean something like this ? (not proofed so far because im at home at the momen)

declare...

Oh, im sorry for that i thought its the same.

Attached the actual plan

Thanks

Chris

Thx,

@Phil, yes i will try to get a dev copy, for sure its better to work with

@dev thx for answering but this does not work because the table1.id is a...

Hi Phil,

thank you for the imediate response, i changed my query to your advise ... but its not faster at all.

Investigating the execution plan gives me the information that there...