Which Oracle book was this?
Date: Fri, 24 Oct 2008 15:16:06 -0700 (PDT)
Years ago, I skimmed an Oracle book at the bookstore. I'm sure it was written by Tom Kyte.
In it, he critiqued a system that would store data in
rows, instead of simple columns!
One criticism being that it performed very badly.
So, instead of a typical table structure:
There was a lookup table with field codes, and what they meant.
The "data" table would be structured:
Doing simple queries was of course much more complex.
I remember reading words to the effect:
"How did it perform? Horribly, pathetically, awfully!"
I'm unfortunately dealing with such a system now, and would like to show this critique to the brass.
Which book can I find this in please?
Thanks a lot! Received on Fri Oct 24 2008 - 17:16:06 CDT