ANALYZE TABLE command slowed the query performance

I have star schema query which executed in couple milliseconds after I enable/running ANALYZE TABLE command the query execution went to 2 seconds consistently.

Anybody has any suggestions or why?

Collecting a profile of the query (SingleStoreDB Cloud · SingleStore Documentation) before and after would help answer this sort of question.

After ANALYZE the query plan will be reoptimized based on the collected statistics - the original query plan might have just gotten “lucky” compared to the new one.