An indexing method that keeps a separate sort order and pointers to the data, independent of the data's physical storage order.
Unlike a clustered index, a table can have multiple non-clustered indexes. Most covering indexes are built this way, and having several tailored to different query conditions can improve overall query performance.
© 2026 ITBGM