Not a DBA, but have done a google on this.
I can use the following to create a histogram on a indexed cloumn.
But do anyone knows how do i verify that histogram is created?
Select count(*) buckets from user_tab_histograms (Is this correct?, but seem to be getting 0 rows.)
I'm doing this as i hope it can improve the query time of this table which consists of around 4 millions rows.