One great feature in the Oracle DB that I used for optimization performance several times is pipelined table functions. Pipelined table functions have been around for a while, and it has a broad range of possibilities.If you are looking for speeding up your ETL, writing files in parallel, skipping the row by row processing. This is a must-have in the toolkit of a developer.