Problem with long running query

Question

Viewing 5 posts - 16 through 20 (of 20 total)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

If you can post the new plan we can look it over to see if we can improve it further. 5 seconds is still slow in my book

christian 92959 SSC Veteran Points: 297 More actions · Answer 2

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

and thank you

Chris

I want to know all secrets about MS SQL Server :w00t:

christian 92959 SSC Veteran Points: 297 More actions · Answer 3

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

I want to know all secrets about MS SQL Server :w00t:

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

What are the indexes on the table Arueck?

This shouldn't scan!

christian 92959 SSC Veteran Points: 297 More actions · Answer 5

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 part of the query

Thx

Chris

I want to know all secrets about MS SQL Server :w00t:

Cookies on SQLServerCentral