What is the difference between a pool table and a transparent table and how they are stored at the database level.

1. Transparent tables have one to one relation ship ie., the structure which defined in the data dictionary level(here we define the tables etc..) is same as in database level(here the data is stored physically).
2. we usually create transparent tables only.

3. In cluster and pooled tables they have many to one relationship ie., they have many structures or definitions at dictionary level but a single table in database level.
4. Major difference is cluster tables must have at least one primary key common but in pooled they may have or may not have a primary key in common.
5. We don

Leave a Reply

Your email address will not be published. Required fields are marked *