Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

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

Tag: union all

Generating data: union all vs insert all

February 11, 2021December 21, 2022 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. This is how I did it.

Snail with rocket
Read More »

Categories

  • Oracle (29)
  • PL/SQL (11)
  • Optimization (9)
  • Coding practice (7)
  • PL/Scope (7)

Tags

  • Oracle (16)
  • PL/SQL (11)
  • SmartDB (9)
  • 12c (6)
  • PL/Scope (6)

Year

  • 2022 (2)
  • 2021 (1)
  • 2020 (1)
  • 2019 (3)
  • 2018 (13)
Blog at WordPress.com.
Back to top
  • Follow Following
    • - nice theory...
    • 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...