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.

statistics1

Define the parameters and press OK.

statistics2.jpg

 

statistics3

DONE!

If you want to be sure, go and check the Statistics tab:

statistics4