educative.io

Educative

Primary Key and Indexes

Hi, I really enjoy the course “An Introductory guide to SQL”. I would say it is the best SQL course I have ever seen. Thank you a lot for your hard work.
I am quite lost in the section of Primary Key and Indexes, could you please explain them again step by step how the data (here the table will be stored and how to index for both cases clustered and non-clustered). I tried to read and look at the graphs but still could not understand how it works. Thank you a lot!
Van


Type your question above this line.

Course: https://www.educative.io/collection/5352985413550080/6335716377231360
Lesson: https://www.educative.io/collection/page/5352985413550080/6335716377231360/5601324986007552

The clustered index is the one that links each row to its physical location on the hard disk. Leaf nodes, in this case, include pages that contain the actual data. On the other hand, the non-clustered index stores a pointer to data stored elsewhere on the disk in leaf nodes. The MyISAM database engine, or ISAM (Indexed Sequential Access Method), is an indexing algorithm developed by IBM that allows retrieving information from large sets of data in a fast way, especially when using a heap table with no order.

1 Like