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
Cancel

 
Loading Comments...
Comment
    ×