overlapping ranges with priority

select .. from ranges_output_view where sku_group = s.sku_group;

end loop;

The predicate gets pushed down to the table, hence partition elimination kicks in and I can visit the input table one time only, one partition at a time, using a fraction of the resources at a time, and hence vastly improving performance.

And that naturally leads to “do-it-yourself parallelism”: running a job for every partition in parallel. I’m going to implement it since the customer is salivating about it … even if it is probably over-engineering :D .

Page 3 of 3 | Previous page

5 comments on this post.
  1. Overlapping ranges with priority | An Oracle Programmer:

    [...] few years ago, Alberto Dell’Era blogged about product prices with overlapping date ranges; “on an overlapping range, the strongest priority (lower number) wins.” His analysis, [...]

  2. www.youtube.com:

    Take your time to read about these other customer’s experiences as this can point you to the best professional for your job.
    Hence, a reasonable service warranty gets counted as an critical trait and top
    quality of a fantastic plumber. The best place to look will
    have to be on the internet.

  3. city2345.com:

    Those who are interested in nature trails and campsites, the key location are in Mt.
    New York City has two main Airports, La Guardia and JFK Airport.
    Some people take a couple weeks every summer, or whenever they have the most time off, and target one of these fantastic tourist destinations.

  4. anxiety treatment online:

    My brother recommended I might like this website. He was entirely
    right. This post truly made my day. You cann’t imagine simply how much time I had
    spent for this info! Thanks!

  5. css slider code:

    Hi, I think your blog might be having browser
    compatibility issues. When I look at your blog in Opera, it looks fine but when opening in Internet
    Explorer, it has some overlapping. I just wanted to give you
    a quick heads up! Other then that, wonderful blog!

Leave a comment