|
-
min and max functions from 10 million records
In a Table with 10 million records,
I want to find min and max of a column,
that column will hardly be 20 distinct values,
What is the best efficient way to find
min and max values of that column other than
using min and max functions.
If I use min and max functions it takes 5 minutes..at least.
That column is indexed.(B-tree)..
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|