SQL behind Business Intelligence
I found something funny with the Oracle Keep / { First – Last } analytic function, on 11.0.0.6 & 11.0.0.7.
Same thing occurs also on Oracle 10g XE.
For those who don’t have a clue about this function, I wrote a small post on this subject.
Recently, I was helping someone to improve a procedure which fills a table with zero where there is no value for some days.
Instead of cursoring and inserting, I wrote a single query using a partitioned outer join to achieve this. Later in the conversation, I was asked to explain how this was working and I posted about. You [...]
Trying to improve the cross join part by faking it.
Results shows Oracle gains twice while MS SQL Server loose twice.
My proposal about NoCOUG First SQL Challenge