i have around 180million rows and been finding it very slow when i open the data subtab. is there something i must set or unset? just running a select * is fast. there is a primary key on that table.
Also noticed that the pop up window that comes up always showing it doing select with no parallel hint and always order on 2 columns 4 and 5 which are not part of any indexes. There is only 1 primary key on that table. I don't understand why the order by these 2 columns and why it does say using no parallel hint.
" Executing select /*+ no_paralel(sub1) */ * from (select * from ... ) sub1 order by 4 asc, 5 asc "
It takes around 8 mins to display the first 50 rows. does not sound right.
Any ideas of what i could look into.
I am on version 21.4.1 of sqldev and target database is oracle 19c Enterprise edition 19.0.0.0 production version 19.12.0.0.0. I cannot upgrade the sqldev as it is a work lock down software.
thank you