How do you mulitply in a field?
On Aug 16, 3:17 pm, "Roger Carlson"
wrote:
Normalization has always been about physical storage. The specifics
about how it's stored is unimportant, but the fact that the data *is* stored
is. At its heart, normalization is about reducing redundant data, that is,
the data that is physically stored.
Are you saying that normalization does not apply to a VIEW unless it's
materialized? I've never heard this distinction made before and it
doesn't sound correct to me.
Let's go slow. Normalization applies to tables. A SQL base table is a
table and a SQL VIEW (materialized or otherwise) is a table. Where do
you think I'm going wrong?
Jamie.
--
|