Monthly Archives: January 2014
something about the cbo was bothering me
A query similar to this was getting a full table scan. Now we know the NDR in archived, deleted and flag is 1. My initial thought was because of this we would get a full table scan. I was wrong, … Continue reading
Foreign Keys and indexes
In this test case we are going to use two tables with a foreign key. The question is, if we create a foreign key, do we need to add an index on that foreign key column? OPS$ORACLE@VETDEV > create … Continue reading
Posted in Database Stuff
Leave a comment
How do You succeed?
This does not have much to do with Oracle consulting, this is more some life lessons on how do succeed at work. I have learned many lessons in life, one of them is the freedom that comes from being independent … Continue reading
Posted in Database Stuff
Leave a comment