SAP BW (Business Warehousing)
SAP BW (Business Warehousing) Forum
May I know that what advantages does the CLUSTER table attribute have?
Thanks in advance.
Table records are saved to the volume in sequence and can also be read again in sequence. You can use an I/O operation to read blocks greater than 8 KB. This results in much better I/O times, for example, during sequential reading.
The table attribute CLUSTER can be included in the tables. As a result of this attribute, the table contents are no longer distributed evenly among all volumes in individual blocks of 8 KB pages. Instead, if possible, they are stored among the volumes in larger connected blocks.
Sign up for STechies