(Shan Nawaz) The goal of this blog is not to analyze the reasons behind working of Oracle optimize as every database implementation is unique. The main objective is to understand what happens when Oracle optimizer chooses Index Fast Full Scan over Unique Scan.
Tag: Oracle
The importance of the GLOBAL_STATS statistic on partitioned tables
(tonyhasler) I am currently working in a team alongside a gentleman known as Roberto Rigliaco. You are unlikely to have heard of Roberto as he is not (yet) a blogger and not (yet) known on the conference circuit.
Scaling Export and Import Tables Residing in Different Schemas 10gR2
(mdinh) Our team was tasked to unpartion all partition tables.
Side effects of Index Fast Full Scan on OLTP
(Shan Nawaz) The goal of this blog is not to analyze the reasons behind working of Oracle optimize as every database implementation is unique. The main objective is to understand what happens when Oracle optimizer chooses Index Fast Full Scan over Unique Scan.
The importance of the GLOBAL_STATS statistic on partitioned tables
(tonyhasler) I am currently working in a team alongside a gentleman known as Roberto Rigliaco. You are unlikely to have heard of Roberto as he is not (yet) a blogger and not (yet) known on the conference circuit.
Scaling Export and Import Tables Residing in Different Schemas 10gR2
(mdinh) Our team was tasked to unpartion all partition tables.
SQLCL – More secure, now with REST !
(Kris Rice) A new SQLCL build was just posted go grab it and kick the tires. There are well over 100 bug fixes in there so it’s better than ever. Also there’s some new things.
The Hitchhiker’s Guide to the EXPLAIN PLAN Part 40: Why is it so hard to get SQL performance right the first time?
(Iggy Fernandez) The Northern California Oracle Users Group (NoCOUG) has organized quarterly conferences for more than 30 years. As far as anyone can remember, conference attendance has hovered around the 150 mark.
Longer strings in 12c
(connormcdonald) Most people are now aware that in 12c, a VARCHAR2 has been extended from a maximum size of 4000 to 32767 bytes.
SQLCL – More secure, now with REST !
(Kris Rice) A new SQLCL build was just posted go grab it and kick the tires. There are well over 100 bug fixes in there so it’s better than ever. Also there’s some new things.
