Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.

Question

Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.​

Quizplus · Accepted Answer

An index is a data structure that facilitates efficient lookup of records or rows in a table, but it does not impact the physical sequence of records on the storage device. The physical ordering of records is typically determined by the storage engine or file system used by the database system.

Unlike a Sort Order, an Index Has No Bearing on the Physical