Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select /*+ parallel(a) */ min(action_objid) from TMP_OA a;
- select /*+ parallel(a) */ max(action_objid) from TMP_OA a;
- partition 1=min(action_objid) + 1* (max(action_objid) /10)
- partition 2=min(action_objid) + 2* (max(action_objid) /10) -partition 1
- ....
- partition 10=min(action_objid) + 10* (max(action_objid) /10) - all nine partitions
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement