Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

– Good and not so good ideas on software development and Oracle databases in particular

Category: I/O efficiency

Generating data: union all vs insert all

February 11, 2021February 11, 2021 NiceTheoryVidarLeave a comment

To test out different physical table lay-outs, I had to repeatedly generate some test-data. After a few runs, I wanted to speed it up a bit.

Snail with rocket
Read More »

As time goes by: When joins spill to disk

March 14, 2017March 14, 2017 NiceTheoryVidarLeave a comment

Large joins may use full scans and hash joins. If your tables are large enough, this will fill up your process working memory and start spilling to your temp-tablespace. At that time a few important effects come into play:

Read More »

Blog at WordPress.com.
Back to top
  • Follow Following
    • - nice theory...
    • Join 312 other followers
    • Already have a WordPress.com account? Log in now.
    • - nice theory...
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...