If you have a huge set of data and you need to efficiently divide it up into subsets, what is the best way to do it? Using an index probably isn't going to work because you're still scanning lots of data. Using a full scan to get each subset probably just makes the problem even worse.
DBMS_PARALLEL_EXECUTE has some usefulness, but can we go one step further? Can we get the optimal way to separate data into chunks???
blog: connor-mcdonal...
twitter: / connor_mc_d
Subscribe for new tech videos every week
All other social media channels here: linktr.ee/connor
Are you serious? A free Oracle database forever ?!?!?!?! Hell yeah!!!
www.oracle.com...
Music: Night Owl (Broke For Free)
, Dyalla
#oracle #rowid #dbms_parallel_execute
6 сен 2024