Row Storage

The database stores rows in data blocks. Each row of a table containing data for less than 256 columns is contained in one or more row pieces.

jboss enterprise application platform training courses malaysia

If possible, Oracle Database stores each row as one row piece. However, if all of the row data cannot be inserted into a single data block, or if an update to an existing row causes the row to outgrow its data block, then the database stores the row using multiple row pieces.

oracle java training courses malaysia

Rows in a table cluster contain the same information as rows in nonclustered tables. Additionally, rows in a table cluster contain information that references the cluster key to which they belong.

java programming training courses malaysia

See also

“Data Block Format” to learn about the components of a data block

dynamics 365 marketing training courses malaysia

Comments

Leave a Reply

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