Blog Aggregator - Amardeep Sidhu

In yesterday’s article I posted the first half of an email interview with Phil Bates, architect for Oracle Business Intelligence Enterprise Edition based down in Bristol, UK. Phil’s focus is on the vision, direction, architecture and development strategy for Oracle Business Intelligence products, and in today’s posting we ask him about the integration of Oracle […]

In yesterday’s article I posted the first half of an email interview with Phil Bates, architect for Oracle Business Intelligence Enterprise Edition based down in Bristol, UK. Phil’s focus is on the vision, direction, architecture and development strategy for Oracle Business Intelligence products, and in today’s posting we ask him about the integration of Oracle […]

A few days ago, a developer and I had an interesting conversation. The developer was trying to tune an expensive SQL statement, using following trial-and-error method:

loop until acceptable performance
explain plan -> execute SQL with sql trace -> tkprof -> rewrite
end loop;

After looking at his method in amusement, I showed him how […]

Based on the discussions on whether there’s any performance benefit in storing indexes separately from tables, I’ve had a number of questions on how can one actually determine exactly how an index range scan is performed. How for example can one determine whether an index I/O is following by a table I/O in a serial manner.
I thought therefore […]

Keith Murphy wrote about the open/closed source debacle and the first comment on that post was:
Monty makes all this money from the Sun acquisition, and pretends to be a free software advocate. How much did he make? How much is he giving back to the MySQL community?
Now, Keith rightfully met this with “grow up”. […]