The below are the major differences between transparent, pooled and cluster tables in SAP data dictionary .
|Transaparent Tables||Pool Tables||Cluster Tables|
|Contain a single table. Used to store master data||They are used to hold a large number of very small tables(stores system data).||They are used to hold data from a few number of large tables.(stores system data).|
|It has a one-to-one relationship with a table in the database.||It has a many-to-one relationship with a table in the database.||It has a many-to-one relationship with table in the database.|
|For each transparent table there is one associated table in the database.||It is stored with other pooled tables in a single table called table pool in the database.||Many cluster tables are stored in a single table in the database called a table cluster .|
|The database table has the same name, same number of fields and the fields have the same names .||The database table has different name, different number of fields and fields have different names.||The database table has different name, different number of fields and fields have different names.|
|There is only a single table .||Table pools contain more tables than table clusters .||Contains less tables than table pools .|
|Secondary indexes can be created .||Secondary indexes cannot be created .||Secondary indexes cannot be created .|