min and max functions from 10 million records

[abhaysk]

Originally posted by engiri
If I use min and max functions it takes 5 minutes..at least.
That column is indexed.(B-tree)..

Check out the plan