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
Bind Peeking
-
Here’s a simple detail about bind peeking (during optimisation) that makes
a big difference to “fetch first/next” queries. The optimizer knows about
your b...
Acum 2 zile
Niciun comentariu:
Trimiteți un comentariu