Quote Originally Posted by slimdave
Nonsense. Just "Select count(*) from MINIAL.CHARGES" and let Oracle work out the fastest way. If there's an appropriate index then it will be used.
If only there were a silver bullet for select count???