Databases Reference
In-Depth Information
In step 5, we executed a simple query against this schema, to retrieve the data of a single
friend (a common query for OLTP environments). We get the following output upon execution
of this query:
Observe the following statistics:
In step 6, we have restructured the schema applying denormalization, then we integrated
in
Phone
table attributes from the lookup tables
Availability
and
Phonekind
, and
re-analyzed the table to reflect the changes in the statistics.
In step 7, we cleared the cache; the operation is pointless as we have changed the schema,
so the entries in the library and buffer cache are not usable. Then in step 8 we executed a
query logically equivalent to the previous one, obtaining the following output:
