troubleshooting Question

Efficiency in Microsoft SQL 2008 QUERY

Avatar of Brock
BrockFlag for Canada asked on
Microsoft SQL Server 2008
5 Comments1 Solution263 ViewsLast Modified:

I have this monsterous "report-to" query that necessitates the use of the following

Select columns from tables where reports_to > '    '
Select columns from tables  where reports_to ='    '.

I had to do this because  the records with the blank values  would be repeated a zillion times.

Do you see how this query could be designed differently.  I have not used any of the optimizing tools in sql query Analyzer to see it the query is effecient yet.  But I will do this as soon as I get the DBA to give me permission to these tools.

Thank you,
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros