Optimized PIVOTing 10g
LuckysMar 26 2008 — edited Mar 27 2008Hi,
Is there any other approach to pivot data (rows to columns) apart from MAX(DECODE(...?
The problem I have is that the data model handles many key things as a sort of attributes to certain objects, e.g. Person.
I understand this is to have greater flexibility in creating ad hoc attributes on the fly for any object but is proving to be a problem whilst reporting against them. As the only methodology to adopt here is to transpose the data, and allow users to query on them.
There other objects within the database which carry nearly 20-25 attributes, rounding to nearly half a million rows within a table.
Pivoting on the basis of MAX(DECODE... is taking lot of time to query information, are there any other work arounds?
Please advice.