AppEngine Performance issue

AppEngine Performance issue

Hi All,

One of our jobs that consist AE was taking 10 minutes earlier and now a days it is taking 35 +minutes to get completed.

The SQL it is getting stuck at "ANALYZE TABLE %Table(REC1_TAO) COMPUTE STATISTICS".
Can you let me know what I can do to tune SQL and performance?

We have tried to use %UpdateStats(REC1_TAO,high) but not working, tried to check Indexing aswell no luck.

PS ver 8.9
Tool: 8.48