Hi all,
I have a tricky situation ... I have a table
columns are
owner varchar2(),
name varchar2(),
ana_tm number
ana_tm represents how much time it took to perform statistics collection for owner.name value. the number ranges from 0 to about 12000 right now, and is subject to change. and say sum(ana_tm) over the table is say X.
What I'd like to have is split this data into say N groups (Let's say 8),
so that each group ends up having a sum(ana_tm) ~ X/N (i.e. X/8 in this example).
What I need is a way in SQL to splice the table list in eight groups so that when I run a parallel 8 stream analyze, they all roughly take same amount of time. I tried width_bucket() and it doesn't give me things that I need. It assumes a linear distribution, which I do not have.
Is this possible to do in SQL only?
Thanks in advance, yes, you can go crazy with syntax, it is 9202.
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
