3 Replies Latest reply on Sep 5, 2014 6:02 PM by Gary Graham-Oracle

    MySQL connections add no LIMIT clause. Making unfiltered queries really slow and heavy

    Mysticalp

      Sometimes I want to select * from some table just to see some sample data and its format.

      When using SQL Developer with an Oracle database it's no problem at all.

       

      The issue appears when I try to do the same in a MySQL database. As it will try to get the entire table in the server before showing me the first rows in the query result tab.
      Is there anything that I can configure or should I just add a LIMIT clause to every query similar to this one?

       

      Thanks and regards