The best replacement for clustered index is non clustered index.


The best alternatives to clustered index are rated as following:
★★★★★  non clustered index
★★★  primary key
★★★  non clustered
★★★  heap
★★  non-clustered index
★★  non-clustered
★  unique index
★  secondary index
★  nonclustered index
★  index organized table
★  index
  covering index
  nonclustered
  unclustered index

Your alternative for clustered index is not listed? Suggest!
Speaking about clustered index, one probably shouldn't forget about primary key.

Other search terms related to clustered index and their ratings are:

★★★★★ primary key
non primary key
clustered index
You have in mind a companion for clustered index and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of clustered index in all years. Click on graph for more.
clustered index
non clustered index
primary key