Saturday, January 16, 2016
Weekend Learning: Creating statistics on global temporary tables
While the note "How to Create Statistics on Global Temporary Tables" on My Oracle Support from article ID 351190.1 is talking about post 126.96.36.199 Oracle databases, it also has specific information on how this is different for 12c and introduces the idea of dynamic sampling as well! How does this apply to you? Well, I have seen system generated global temporary tables perform badly where you really do not have any control over it, so this could possibly give you some kind of control!