I need optimization recommendations (Don't have access to modify index) for this query, I ommited some variable names for security reason, but this is basically my query, it fluctuates around 300 to 900 milliseconds to complete, when I use c# it's a little faster, but I want to get below the 100 milliseconds. SQL SERVER 2008I need optimization recommendations (Don't have