Avatar

Community Advisor

Hi @Klaster ,

This is nice idea as direct-path insert can perform significantly better than conventional insert.

However, there are some constraints here:

  • Data is written directly into datafiles, bypassing the buffer cache;
  • Free space in the table is not reused;
  • Rreferential integrity constraints are ignored.

 

Regards,

Milan