Last post Aug 07, 2017 06:47 AM by Rajeshsomvanshi
Aug 04, 2017 11:22 AM|rajeshsomvanshi|LINK
I have below SQL query. It is taking a so much time to execute.could you please help on this?
How can I improve to my below query performance? I have done done all the indexes which one is required.
Select * from Test
Aug 04, 2017 11:30 AM|mgebhard|LINK
See the following document on SQL performance tuning.
Aug 07, 2017 12:49 AM|Deepak Panchal|LINK
you can try to refer points below.
so if you can see your query, you will find that your query is too long and complex.
you are trying to fetch data from multiple tables using joins ,sub query, calculation. so it is expected that it performs slow.
you can try to make changes as mentioned above. maybe the performance will be improved but not noticeable or improvement is very small.
Aug 07, 2017 06:47 AM|rajeshsomvanshi|LINK
Thank you so much for your help.
I have dropped Unused Indexes and now the query is working as expected.