Slow Query

Dekaeron 2014-07-01 16:34:03

Dear friends, I have a problem with this query and it works very slow.

Edward Norris 2014-07-01 16:39:26

Verify your statistics on table4 and table3 are updated.

You can probably remove the Key lookup on table3.index5 by adding an "include (column8, column9)" on table3.index4.

Wow, I love typing in generics! : )

Dekaeron 2014-07-01 16:57:51

Thanks!!!!

July 1, 2014