heroes3lover wrote:

> 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
> Roc
>

Roc,

Maybe 1 minute is just to long too...

The best we can do will be after we se your query and the generated
plan and you provide as much info as possible.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br