Sachin Arora's Blog
Monday, February 9, 2009
Index range Scan Vs Nested loop in IN-LIST ?
›
Which one is better over the above? This question has been the one of the latest topic in our performance team when using a viable solution ...
21 comments:
Friday, December 19, 2008
Partition stats usage with Bind peeking disabled
›
Last week, I was working on a package, which is used to collect stats. I realized we collect stats of all partioned tables,indexes at both p...
3 comments:
Thursday, November 13, 2008
Oracle Bitmap indexes - implementation
›
Oracle uses BBC (Byte aligned Bitmap Code) 1-sided algorithm to store Bitmap indexes. What is BBC? Thinking of Bitmap indexes, m...
1 comment:
Friday, May 9, 2008
ORA-14097 - when using materialized view and partition table
›
This one was an interesting issue which came up few days back. I spent quite sometime before I solved it. Issue was - A developer came upto ...
Thursday, May 8, 2008
Query result cache in 11g
›
In 11g its possible to store the result of the SQL in a special section of shared pool called RESULT CACHE. As the name suggests, this cache...
›
Home
View web version