title: Eliminate sort order on Data tab of SQL Developer table view
body: <p>In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. There is also a 'Sort...' button to set the sort order of the data you are viewing. This can be very handy for viewing some data on the fly. </p>
  
  <p>The problem: I set a sort order for viewing a particular table which is not supported by the indexes on that table.  It seems that SQL Developer does the sort on the fly when you go to view that data.  At first the delay wasn't too bad.  But the table has grown and now it takes forever.  There is no way to stop it except by force quitting SQL Developer, losing anything unsaved.  (If you know another way to stop this sort, let me know!)  So, I should change the viewing sort order to something else, but you can only access the Sort... button when viewing the data. </p>
  
  <p>Is there another way to delete the viewing sort order besides viewing the data?</p>
  
  <p>Where does SQL Developer store this information?</p>
  
  <p>Any way to stop the sorting of the data after clicking on the data tab while waiting for it to appear?</p>