Performance issue for select stmt

Help Query Tuning
1

HI Team
i am executing simple select query with records of LIMIT 50000 but it is taking 2min time how to do the performance on it… can please help some hint or suggestion on it.

2

Please include the query and say how big your data is, what kind of tables it is, etc.

Also, take a look at the graphical profile in SingleStore Studio. That might give you some clues.