Subject Re: How to make my report quicker
Author heroes3lover
Thanks Sean,
you reply so quick!
The SQL for one store is not bad, and the plan is good, I have double
check with my workmates.It should not be the bad performance of
database. As I said, there are more than 400 stores in this group, if I
analyze stores one by one, one store use 1 minute, and 400 stores will
be 400 minutes, it is 6 hours.
Maybe should do something on the database design, can fix this issue.
Do you have some idea about that?

Thank you very much