I have given a presentation about my favourite SQL Developer features several times but those features just keep adding up… Here’s one more (I guess there will be more coming 😀 ).
I needed to test something quickly and part of the test was also gathering the statistics. I was just curious to see if I can do that using SQL Developer (I always do it on command line) and of course I can!
Right-click the table name in the Browser, select Statistics and Gather Statistics.
Define the parameters and press OK.
If you want to be sure, go and check the Statistics tab: