In our enviroment, we choose the second. After cached the table, oracle will be very smart to know that it should read the table from memory instead of read from disk.
http://dbakevin.blogspot.ro/2012/02/serious-performance-issue-caused-by-11g.html
Partition by Expression
-
Oracle 26.1 now allows using an *Expression* in the Partitioning Clause.
In earlier releases, you could do this with a Virtual Column defined in the
ta...
Acum 3 ore
Niciun comentariu:
Trimiteți un comentariu