Re: Convert SAP Oracle Database to IBM DB2 Database??
Date: Sat, 09 Feb 2008 20:44:21 -0500
DA Morgan wrote:
> Depends on the data. Have you looked at bank data? phone company data?
> online reseller data? It isn't as random as you appear to think.
> Consider, for example, the clustering factor on an index. That same
> table that has address information to which you refer also has cities,
> state/provinces, first names, and lots of other very predictably
> repeating values. And, yes, at the block level.
Are you saying that Firstnames strongly correlate with your clustering? Streetnames? What do you think is better: Store "Main Street" and "Smith" in a global dictionary or repeating it in every block.
> What I am surprised you have not yet given voice to is the implication,
> in Oracle, of using small blocks versus large blocks.
You teach. I comment.
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Sat Feb 09 2008 - 19:44:21 CST