Skip to Content
0
Former Member
May 11, 2010 at 02:39 PM

Where we can use pooled and cluster tables.

184 Views

Hi Experts,

I have read all the threads and tutorials. all are telling like the difference between pooled and clulster tables are

Pooled table

It can hold small amount of data ( 10 to 100 records) and large number of tables( 100 to 1000 tables). It has fixed structure like Tabname, Varkey, Datain, Vardata.

Cluter tables

It can hold large amount of data but small number of tables. It is also have fixed strucuter like CLKEY1,CLKEY2 , CLKEY3...., Pageno, Timestamp, Pagelg, Vardata.

But i want which situation we can choose pooled table and which situation we can choose cluster table. In general way or Business way.

Thank you,

Srinivas M

Edited by: Srinivas Marapureddy on May 11, 2010 4:39 PM