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.

--