O'Reilly logo

Teradata Database Administration – Teradata Internals by Tom Coffing, Todd Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8 - Disk Cylinders and the Master Index

“You always know when something works, it's a result of everything firing on all cylinders.”

- Gary Cole

 

Disks have Cylinders which hold Data Blocks

Disks are made up of cylinders and data blocks are stored inside these cylinders

images

A data block always resides inside a disk cylinder. Disks contain thousands of cylinders. A data block never contains data from more than one table, but one table could be contained in many data blocks in many different cylinders if it is large.

 

Rows are Stored in Data Blocks which are stored in Cylinders

Above, you see many rows of a table and they are stored ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required