BIP BIServer Query Debug

With some help from Bryan, I have uncovered a way of being able to debug or at least log what BIServer is doing when BIP sends it a query request. This is not for those of you querying the database directly but if you are using the BIServer and its datamodel to fetch data for [...]

Next Jump and Why Data Win

Ever heard of a company called Next Jump? Me neither until I read this piece in the New York Times (h/t TechCrunch) last week. Next Jump had stayed stealth for 15 years, raising $45 million in venture money and hiring 225 people, all the while signing 60% of the Fortune 500 as customers. Not too [...]

Why are some of the tables in my query missing from the plan?

We apologize for our brief hiatus from blogging. We’ve been busy working on improvements to the optimizer. In 10gR2, we introduced a new transformation, table elimination (alternately called “join elimination”), which removes redundant tables from a query. A table is redundant if its columns are only referenced to in join predicates, and it is guaranteed [...]