Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
37 / 108
What is a Non-Clustered Index?
Answer:
The data rows are not stored in any particular order, and there is no particular order to the sequence of the data pages. In a clustered index, the physical order of the rows in the table is not same as the logical (indexed) order of the key values.
Asked In ::
Priyanka Singh
23 Feb, 2019 5:07 AM
The data rows are not stored in any particular order, and there is no particular order to the sequence of the data pages. In a clustered index, the physical order of the rows in the table is not same as the logical (indexed) order of the key values.
Priyanka Singh
23 Feb, 2019 5:07 AM
The data rows are stored in order based on the clustered index key. Data stored is in a sequence of the index. In a clustered index, the physical order of the rows in the table is the same as the logical (indexed) order of the key values. A table can contain only one clustered index. A clustered index usually provides faster access to data than does a non-clustered index