Hi

Finally Mission Accomplished. Thank you very mush for guide.

The below code made good improvement. (Execution Plan Attached)

some days more than 95% improvement vs old script.

still two problem remain:

1. spill to...

Friends, I've reached to a good improvement.

I destroyed fragmentation for table Groups_Roles Table. Result was very good. My goal procedure removed from SQL Serve Profiler with more than 3 seconds...

I've removed PK of LegalReferrence Table. Logical Read reduced for this table very good.

Hi

Thanks a lot.

I've run your edited query. but its cost was 51% against last improved query that I sent in my last post. And Logical...

Hi

Thanks a lot.

I've run your edited query. but its cost was 51% against last improved query that I sent in my last post. And Logical Read grows up...

Hi

Thanks a lot.

I've run your edited query. but its cost was 51% against last improved query that I sent in my last post. And Logical Read grows up for Table...

Hi

I used join and a covered index. I could reach 1% Improvement. I couldn't use 'Not Exists' instead 'Not IN'.

I've attached last execution plan.

--set statistics io on
--set...

Hi

Thanks for formmating my code.

Also for good suggestions.

I'm going to tune my code based of your guides. And tell you about results.

and this is my target script. I edit subquery in Master query but spill data occured.

I've also attach execution plan.

 Select [Roles].[Role_ID] AS "legalRoleID" , [Roles].[UserID] AS...

• This reply was modified 4 years, 5 months ago by  zamani 41951.

This is old and new script:

I've attached execution plan of below code.

SELECT [Roles_Ex_Rights].[RoleID] FROM [Roles_Ex_Rights] WHERE [Roles_Ex_Rights].[RightID] IN (7295) and IsConfirm = 1    ...

• This reply was modified 4 years, 5 months ago by  zamani 41951.

Hi.

I've attached execution plan.

I've checked Union ALL and it is better and Eliminate Spill Data . Also I've use join for Groups_Roles And Groups_Rights.

Now, I have another problem, When I...

• This reply was modified 4 years, 5 months ago by  zamani 41951.
• This reply was modified 4 years, 5 months ago by  zamani 41951.