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.