troubleshooting Question

SP works but seems slow. Is there a better more effecient way to write this?

Avatar of CAMPzxzxDeathzxzx
CAMPzxzxDeathzxzx asked on
Microsoft SQL Server
12 Comments1 Solution83 ViewsLast Modified:
Is there a better more efficient way to write this SP


CREATE PROCEDURE [dbo].[usp_GetRegistrationQuestions]
AS
BEGIN	
	SELECT 
	  t.[RegistrationQuestionType],
      r.[RegistrationQuestionReturnType],
      q.[RegistrationQuestionID],
	  q.[RegistrationQuestion]
      
  FROM [dbo].[RegistrationAnswerPeopleCluster] c
  INNER JOIN [dbo].[RegistrationQuestionType] t ON c.[RegistrationQuestionTypeID] = t.[RegistrationQuestionTypeID]
  INNER JOIN [dbo].[RegistrationQuestionReturnType] r ON c.[RegistrationQuestionReturnTypeID] = r.[RegistrationQuestionReturnTypeID]
  RIGHT JOIN [dbo].[RegistrationQuestion] q ON c.[RegistrationQuestionID] = q.[RegistrationQuestionID]  
  WHERE c.[PeopleID] IS NULL AND c.[Active] = 1
  GROUP BY t.[RegistrationQuestionType], r.[RegistrationQuestionReturnType], q.[RegistrationQuestionID], q.[RegistrationQuestion]
  ORDER BY q.[RegistrationQuestionID] ASC
END
GO
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 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 12 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