Is there any advantage to denormalizing DB2 tables ?
Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are different types of Tables? 03.11.08
There are 4 types of tables in siebel 1) Base Table (Ex: s_contact, s_user) 2) Extension table ( Ex: s_contact_x) 3) EIM tables 4) Intersection...What is the difference between star schema and snow flake schema ?and when we use those schema’s? 20.09.08
Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...What is the difference between permanent and temporary tables ? 23.07.08
Temporary tables are similar to permanent tables, except temporary tables are stored in tempdb database and are deleted automatically when no longer in use....What are Hashed Tables? 15.04.07
Hashed tables - This is the most appropriate type for any table where the main operation is key access. You cannot access a hashed table using its index. The re...What is the difference between Clustered Tables and Pooled Tables? 12.04.07
A pooled table is used to combine several logical tables in the ABAP/4 dictionary. Pooled tables are logical tables that must be assigned to a table pool when t...How many types of tables exist ? 01.04.07
Four Types of Tables: 1. Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. B...What is the difference between tables and structures? 26.03.07
Tables: 1)Data is permanently stored in tables in the database. 2)Database tables are generated from them. Structure: 1)It contains data temporarily durin...Give the two types of tables involved in producing a star schema and the type of data they hold. 24.01.07
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables....How can you Enforce Referential Integrity in snapshots? 14.11.06
Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in sn...What are internal tables? 12.03.06
Internal tables are a standard data type object which exists only during the runtime of the program. They are used to perform table calculations on subsets of d...