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: